<span style="border-collapse:collapse">Hello,<div> We are trying to do a DBWRITE to an Oracle 10g database. As a test we set up a new table with a single column looking for a string, we put in the SQL statement: insert into CISCO_T(col1) VALUES('12345'); when we do the test it shows Number of Rows Altered: 1 However when we look in the database, nothing is there. Speaking with the DBA he thinks we need a commit statement. However when we add the commit statement, and end out with SQL statement "insert into CISCO_T(col1) VALUES('12345'); COMMIT;" when we do the test again the Number of Rows Altered is 0, and still nothing is in the database. </div>
<div><br></div><div>We have tried changing the "batch autocommit mode" in the ODBC settings from "commit only if all statements succeed", to "commit all successful statements" to see if that would make a difference or not, and still have the same results.</div>
<div><br></div><div>Does anyone have any idea what we are doing wrong? How do we get the DBWRITE to work with Oracle 10g?</div><div><br></div><div><br clear="all">Thank you for your assistance</div><div><br>-- <br>Denis Pointer, A. Sc. T.<br>
Customer Systems Analyst (Senior Design)<br><br>CCVP, CCNA, CCDA<br>Cisco Unified Contact Center Specialist<br>Cisco IP Telephony Design Specialist<br>Cisco Unity Design Specialist<br>Cisco Unity Support Specialist<br>Cisco IP Communications Express Specialist</div>
</span>