Home » Server Options » Replication » PLS-00201: identifier 'SYS.DBMS_REPCAT_UTL2@ORCL.BABU' must be declared
PLS-00201: identifier 'SYS.DBMS_REPCAT_UTL2@ORCL.BABU' must be declared [message #290356] Fri, 28 December 2007 08:59 Go to next message
arthik_babu
Messages: 8
Registered: December 2007
Junior Member
Hi , I am getting following error Please help me to find out

SQL> BEGIN
2
3 DBMS_REPCAT.CREATE_MVIEW_REPGROUP (
4
5 gname => 'ORCL_REP',
6
7 master => 'ORCL.BABU',
8
9 propagation_mode => 'ASYNCHRONOUS');
10
11 END;
12 /
BEGIN
*
ERROR at line 1:
ORA-06550: line 1, column 8:
PLS-00201: identifier 'SYS.DBMS_REPCAT_UTL2@ORCL.BABU' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.DBMS_REPCAT_UNTRUSTED@ORCL.BABU' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_REPCAT_UTL", line 2403
ORA-06512: at "SYS.DBMS_REPCAT_SNA_UTL", line 1721
ORA-06512: at "SYS.DBMS_REPCAT_SNA", line 64
ORA-06512: at "SYS.DBMS_REPCAT", line 1262
ORA-06512: at line 3

Re: PLS-00201: identifier 'SYS.DBMS_REPCAT_UTL2@ORCL.BABU' must be declared [message #290387 is a reply to message #290356] Fri, 28 December 2007 12:11 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what Oracle says:
Quote:

PLS-00201: identifier 'string' must be declared

Cause: You tried to reference either an undeclared variable, exception, procedure, or other item, or an item to which no privilege was granted or an item to which privilege was granted only through a role.

Action:
  • Check your spelling and declaration of the referenced name.
  • Verify that the declaration for the referenced item is placed correctly in the block structure.
  • If the referenced item is indeed declared but you don't have privileges to refer to that item, for security reasons, you will be notified only that the item is not declared.
  • If the referenced item is indeed declared and you believe that you have privileges to refer to that item, check the privileges; if the privileges were granted only via a role, then this is expected and documented behavior. Stored objects (packages, procedures, functions, triggers, views) run in the security domain of the object owner with no roles enabled except PUBLIC. Again, you will be notified only that the item was not declared.


As far as I can tell, the fourth solution is the most common "mistake" - do not grant privileges via a role; try to grant it directly to the user.
Previous Topic: ORA-00119: invalid specification for system parameter LOCAL_LISTENER
Next Topic: No indexes on Materialized view
Goto Forum:
  


Current Time: Thu Mar 28 09:46:40 CDT 2024