Is autocommit available in Pro*C [message #93495] |
Sun, 03 March 2002 23:11 |
slimzhao
Messages: 5 Registered: November 2001
|
Junior Member |
|
|
well, in sqlplus, we can issue such command to turn on autocommit;
SQL> set autocommit on
But, in Pro*C programming, I can't find a method such as proc parameter or EXEC SQL ORACLE OPTION or sqlca.member to do the equivalent.
And, I find in oracle's OCI document as follows:
==============================
Advantages of OCI
OCI provides significant advantages over other methods of accessing an Oracle
database:
n ability to associate a commit request with an execute to reduce roundtrips.
==============================
Does it implicit that Pro*C can't do autocommit?
Anyone has any idea?
thx in adv.
|
|
|
|