help with select for update
From: <emdproduction_at_hotmail.com>
Date: Wed, 14 Jan 2009 08:47:34 -0800 (PST)
Message-ID: <20d6eccc-4369-4422-8088-3dd621574f23_at_y1g2000pra.googlegroups.com>
Dear group,
Date: Wed, 14 Jan 2009 08:47:34 -0800 (PST)
Message-ID: <20d6eccc-4369-4422-8088-3dd621574f23_at_y1g2000pra.googlegroups.com>
Dear group,
I am trying to debug a problem with FGAC, i enable the policy on a
table
When i do
SQL>select count(*) from tableA where col=1;
COUNT(*)
1
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