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,

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

Original text of this message