php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #3520 Fetch PB with select ... for update
Submitted: 2000-02-17 16:32 UTC Modified: 2006-07-17 08:58 UTC
From: eric dot poisse at cermex dot fr Assigned:
Status: Not a bug Package: OCI8 related
PHP Version: 3.0.12 OS: Linux 2.2.5
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: eric dot poisse at cermex dot fr
New email:
PHP Version: OS:

 

 [2000-02-17 16:32 UTC] 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-02-17 16:48 UTC] 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!
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Thu Dec 26 13:01:30 2024 UTC