Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Policy Implementation

653361Jul 16 2009 — edited Jul 16 2009
Please, this is the problem am facing while trying to implement the FGAC in my DB.
When compiling this, I get the following errors when doing this query:
ora-06553: wrong number or types of argument in call no_dept10

I am trying to add it to a prediacte, so, I get the following:

ora-28113: policy predicate has error
create or replace function no_dept10(
p_schema in varchar2,
p_object in varchar2)
return varchar2 as
begin
return 'USER != "system"';
END;
/

PLease, i took this from a book and if there is a way out or what am missing here.
This post has been answered by 21205 on Jul 16 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2009
Added on Jul 16 2009
3 comments
333 views