This content has been marked as final. Show 1 reply
Make sure that every ociexecute call uses OCI_DEFAULT, else the active transaction in the connection will be committed.
Make sure that your application isn't doing DDL, e.g. CREATE TABLE, since this will commit the active transaction.
Pending transactions are shown in v$transaction, which may (or should) not be visible to normal users.
By "list of pending transactions, on that connection" do you means list of SAVEPOINTS, or are you suspending transactions via
a transaction manager or even by DBMS_XA?
Use <?php phpinfo(); ?> and check you have a recent version of the PHP OCI8 extension. 1.3 onwards is OK, 1.4 onwards is good.
You can get the latest source from http://pecl.php.net/package/oci8