#18621 [NEW]: Can't lock row in oracle8i
| From: | satit at thambun dot com | Date: | Mon, 29 Jul 2002 13:10:35 +0000 |
| Subject: | #18621 [NEW]: Can't lock row in oracle8i | ||
| Groups: | php.bugs | ||
| Request: | Send a blank email to php-bugs+get-15486@lists.php.net to get a copy of this message | ||
From: satit@thambun.com
Operating system: windows2000
PHP version: 4.2.1
PHP Bug Type: OCI8 related
Bug description: Can't lock row in oracle8i
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 bug report at http://bugs.php.net/?id=18621&edit=1
--
Fixed in CVS: http://bugs.php.net/fix.php?id=18621&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=18621&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=18621&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=18621&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=18621&r=support
Expected behavior: http://bugs.php.net/fix.php?id=18621&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=18621&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=18621&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=18621&r=globals