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 Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
45 + 8 = ?
Subscribe to this entry?

 
 [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

Add a Patch

Pull Requests

Add a Pull Request

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: Sat Apr 20 15:01:29 2024 UTC