Re: OCIRollBack() doesnt work

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. -Andreas -- Andreas Karajannis GMD National Research Center for Information Technology Schloss Birlinghoven, D-53754 Sankt Augustin Phone +49 2241 142948