3 Replies Latest reply: Aug 29, 2005 10:46 AM by 441033 RSS

    DBMS_RLS : identifier 'DBMS_RLS' must be declared

    441033
      I am trying to use DBMS_RLS.add_policy on Oracle9i Enterprise Edition Release 9.2.0.6.0. But I get an error as follows:

      SQL> ed
      Wrote file afiedt.buf

      1 begin
      2 system.dbms_rls.add_policy
      3 ( object_schema => 'CST2QCC',
      4 object_name => 'KJ',
      5 policy_name => 'MY_POLICY',
      6 function_schema => 'CST2QCC',
      7 policy_function => 'My_Security_Function',
      8 statement_types => 'select, insert, update, delete' ,
      9 update_check => TRUE );
      10* end;
      SQL> /
      system.dbms_rls.add_policy
      *
      ERROR at line 2:
      ORA-06550: line 2, column 8:
      PLS-00201: identifier 'SYSTEM.DBMS_RLS' must be declared
      ORA-06550: line 2, column 8:
      PL/SQL: Statement ignored


      Can anyone please tell me the reason for this.

      Thanks
      Kshama