help with select for update
Date: Wed, 14 Jan 2009 08:47:34 -0800 (PST)
I am trying to debug a problem with FGAC, i enable the policy on a
When i do
SQL>select count(*) from tableA where col=1; COUNT(*)
I can get the row without problem
But when i do
SQL>select count(*) from tableA where col=1 for update nowait; no rows selected
I do not see any errors, and i can not get the lock neither.
What could be wrong?
Thanks for your help Received on Wed Jan 14 2009 - 10:47:34 CST