Home » Developer & Programmer » Precompilers, OCI & OCCI » Is autocommit available in Pro*C
Is autocommit available in Pro*C [message #93495] Sun, 03 March 2002 23:11 Go to next message
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.
Re: Is autocommit available in Pro*C [message #93499 is a reply to message #93495] Thu, 14 March 2002 02:40 Go to previous message
MOE
Messages: 14
Registered: February 2002
Junior Member
Autocommit? Where the hell do you need that?
Previous Topic: How can I get the Parameters of a procedure?
Next Topic: Not found Pro C in Oracle8i on Linux
Goto Forum:
  


Current Time: Sun Nov 24 13:51:21 CST 2024