[cisco-voip] DB Write Oracle 10g how do we commit?

[Denis Pointer]

Hello,   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.

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.

Does anyone have any idea what we are doing wrong?  How do we get the
DBWRITE to work with Oracle 10g?


Thank you for your assistance

-- 
Denis Pointer, A. Sc. T.
Customer Systems Analyst (Senior Design)

CCVP, CCNA, CCDA
Cisco Unified Contact Center Specialist
Cisco IP Telephony Design Specialist
Cisco Unity Design Specialist
Cisco Unity Support Specialist
Cisco IP Communications Express Specialist
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090817/1f0404c7/attachment.html>