Re: OCIRollBack() doesnt work

On Thu, Oct 26, 2000 at 09:51:33AM +0200, Andreas Karajannis wrote: > omar cromwell mercado wrote: > > > > Hi, > > I wonder why ocirollback() wont work in my case, > > though > > it does work in sqlplus using same account. My php is > > compiled with --with-oci and --with-oracle. Below is > > my code. I appreciate if someone can point me the > > right > > way of using ocirollback() if my code is incorrect. > > Thanks a lot. I appreciate any comments. > > You have to add OCI_DEFAULT as additional parameter to ociexecute(), > otherwise you implicitly do a commit after successful execution. > Be careful to add this to all your calls to ociexecute(), otherwise you > implicitly commit your update with the second select query. This is > since commit works on session level, meaning all pending transactions on > a session are commited. http://www.php.net/manual/function.ocinlogon.php has a sample on transaction isolation. tc > > -Andreas > > -- > Andreas Karajannis > GMD National Research Center for Information Technology > Schloss Birlinghoven, D-53754 Sankt Augustin > Phone +49 2241 142948 > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > >