Skip to main content
Ex Libris Knowledge Center

Oracle Data Pump: "PLS-00201: identifier 'RC' must be declared"

  • Article Type: General
  • Product: Aleph
  • Product Version: 18.01

Description:
In trying to use the Oracle data pump to import some data (exported with data pump -- not as part of Upgrade Express but just to move the data to a different server) , I am receiving an "identifier 'RC' must be declared" error:

Starting impdp_oracle_library_a
Mon Apr 20 12:06:06 CDT 2009

create_ora_user_b LAW60

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Apr 20 12:06:07 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter user-name:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

aleph_admin@A112_A18> EXIT
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64b
it Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Apr 20 12:06:07 2009

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

Enter user-name:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

aleph_admin@A112_A18>
User dropped.


User created.


Grant succeeded.

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64b
it Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Directory LAW60_DIR already created

Call completed.

BEGIN rc('/bin/chmod +r /exlibris/aleph/u18_1/law60/files/dpdir/LAW6001.dmp.gz');
END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'RC' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored


BEGIN aleph_admin.call_os_cmd('/bin/gunzip /exlibris/aleph/u18_1/law60/files/dpd
ir/LAW6001.dmp.gz'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'ALEPH_ADMIN.CALL_OS_CMD' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Note: Prior to this, I did

s+ ALEPH_ADMIN
grant JAVA_ADMIN to aleph_admin WITH ADMIN OPTION;

and the "select COMP_NAME,STATUS from dba_registry;" shows "JServer JAVA Virtual Machine" as valid.

Resolution:
The problem is that a key setup script had not been run on the database. To fix it, use the following commands:

$ cd $aleph_proc
$ sqlplus $ALEPH_ADMIN
> @oracle_expdp_current_lib.sql

This will create the necessary procedures and java utilities that are used by the impdb scripts. A call to run this SQL script is included in the *expdp* scripts and in the v.20 version of oracle_impdp_current_library_a, but is not included in the import scripts for previous versions.


  • Article last edited: 10/8/2013