Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> RLS with exceptions
I am implementing Oracle's RLS package and I have added user defined exceptions to my policy functions. These user defined exceptions are raised when a user does not have permission to execute the statement type. I run a script that attempts to issue select, insert, update and delete statements for a user on each table for which the policy has been enabled. After each statement type I check the sql%rowcount. I've discovered that if the user defined exception is raised by the policy function, the sql%rowcount is not accurate. Any ideas as to why this is happening and how it can be avoided???
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Aug 07 2000 - 00:00:00 CDT
![]() |
![]() |