php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #18621 Can't lock row in oracle8i
Submitted: 2002-07-29 09:10 UTC Modified: 2002-11-26 15:35 UTC
From: satit at thambun dot com Assigned:
Status: Not a bug Package: OCI8 related
PHP Version: 4.2.1 OS: windows2000
Private report: No CVE-ID: None
 [2002-07-29 09:10 UTC] satit at thambun dot com
I would like to lock row for update but it can't lock .If I lock row in sql*plus by sql command "select * from table where ... for update nowait" it can check lock and display massage 'read only'. How can I do?

my code:
...
    $gcom ='select * from admin.USERS where ACCOUNT = '."'".$ACCOUNT."' for update nowait";
    $result = OCIParse($conn, $gcom);
    $chk = OCIExecute($result,OCI_DEFAULT); 
   if(!$chk){
     $gcom ='select * from admin.USERS where ACCOUNT = '."'".$ACCOUNT."'";
     $mess = "Read only";
    $result = OCIParse($conn, $gcom);
    $chk = OCIExecute($result,OCI_DEFAULT); 
    }else {$mess="Read/Write";}
    echo $mess;
     $rows = OCIFetchStatement($result,$results);
     ...

Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2002-11-26 15:35 UTC] maxim@php.net
Sorry, but your problem does not imply a bug in PHP itself.  For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions. 

Thank you for your interest in PHP.


 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Apr 25 01:01:30 2024 UTC