I do have a shema named PRACTICE with its own table named EMPLOYEES.
The table has fields: empid,fname,sex and age.
Their data types are varchar2,varchar2,varchar2 and number respectively.
The fields also held values LA,Lensa,F and 21 respectively.
Being on the sys schema, I defined a policy for auditing purpose as follow.
When I tried to execute a statement- update employees set fname='Girma' where empid='LA',
I got the following error message:
ERROR at line 1:
ORA-28138: Error in Policy Predicate.
Please help me, I am waiting for your help. Thanks!
May 25, 2010 12:44 PM
May 25, 2010 4:05 PM