Re :Re: [PHP-DB] How use select for update
| From: | Chris | Date: | Thu, 16 Sep 2004 08:31:01 +0000 |
| Subject: | Re :Re: [PHP-DB] How use select for update | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-36224@lists.php.net to get a copy of this message | ||
Escuse me i forgot the "t"
> Is row-level locking happening?
> I think that the lock doesn t work
>
> When are you checking the locks?
> I am checking the lock with an SQLPLUS session
>
> If i lock my table with SQLPLUS, PHP can make an select for update
> But if i try to lock with PHP i can make an other select for update
with
> sqlplus
> So my lock doesn t work
>
If i lock my table with SQLPLUS, PHP can T make an select for update
I have the same code
$query = 'select * from emp for update nowait';
$stid = OCIParse($conn, $query);
$r = OCIExecute($stid, OCI_DEFAULT);
But my problem, it s that i can t lock my table with PHP
I haven t problem with SQLPLUS