Got Ora-28112 failed to execute policy function error, please help
324771Dec 2 2009 — edited Dec 2 2009Hi,
I have created the following function:
==============================
create or replace function test_job
return varchar2
as
deptinfo varchar2(100);
begin
deptinfo := 'dept_id=123000';
return(deptinfo);
end test_job;
/
==============================
and the policy:
==============================
begin
dbms_rls.add_policy(object_schema =>'myself',
object_name => 'myself_account_info',
policy_name =>'test_policy',
function_schema => 'myself',
policy_function => 'test_job');
end;
/
==============================
While I execute the sql statement
'select * from myself_account_info';
I got this ora-28112 error. Could anyone help me to pinpoint the problems?
Thanks!