Re :Re: [PHP-DB] How use select for update

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux