#3520 [Csd->Bgs]: Fetch PB with select ... for update

ID: 3520 Updated by: tony2001@php.net Reported By: eric dot poisse at cermex dot fr -Status: Closed +Status: Bogus -Bug Type: Oracle related +Bug Type: OCI8 related Operating System: Linux 2.2.5 PHP Version: 3.0.12 Previous Comments: ------------------------------------------------------------------------ [2000-02-17 16:48:18] thies at cvs dot php dot net please do: .... OCIExecute($stmt,OCI_DEFAULT); .... OCICOmmit($connection); the problem is that the default mode for OCIExecute is OCI_COMMIT_ON_SUCCESS - which ends the current transaction. that way "select ... for update" cannot work. BTW: theres an ocierror function that would have given you some insights! ------------------------------------------------------------------------ [2000-02-17 16:32:30] eric dot poisse at cermex dot fr When I use the Select <xxx> from <table> FOR UPDATE, There is a Fetch PB during the execution of the OCIfetch function This PB don't appears without the FOR UPDATE clause. $stmt = @OCIParse($connection, "select * from services for update"); // Calcul du nombre de lignes total de la requete if (@OCIExecute($stmt)) { while (OCIFetch($stmt)) { .... } PHP Compiled with --oracle lib ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=3520&edit=1