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