ID: 18621 Updated by: [EMAIL PROTECTED] Reported By: [EMAIL PROTECTED] -Status: Open +Status: Bogus Bug Type: OCI8 related Operating System: windows2000 PHP Version: 4.2.1 New Comment:
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. Previous Comments: ------------------------------------------------------------------------ [2002-07-29 09:10:34] [EMAIL PROTECTED] 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); ... ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=18621&edit=1