Error while Archived
file : https://www.dropbox.com/s/nl16uiqhvyayjvu/oim_create_recon_arch_tables.sql?dl=0
SQL> @/apps/db/Archive/Utilities/Recon11gArchival/ SQL> @/apps/db/Archive/Utilities/Recon11gArchival/oim_create_recon_arch_tables.sql
l_arHTnames OIM_TYP_CharArr := OIM_TYP_CharArr();
*
ERROR at line 4:
ORA-06550: line 4, column 25:
PLS-00201: identifier 'OIM_TYP_CHARARR' must be declared
ORA-06550: line 4, column 25:
PL/SQL: Item ignored
ORA-06550: line 5, column 18:
PLS-00201: identifier 'OIM_TYP_NUMBERARR' must be declared
ORA-06550: line 5, column 18:
PL/SQL: Item ignored
ORA-06550: line 179, column 14:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 177, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 182, column 12:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 182, column 9:
PL/SQL: Statement ignored
No errors.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
l_arHTnames OIM_TYP_CharArr := OIM_TYP_CharArr();
*
ERROR at line 4:
ORA-06550: line 4, column 25:
PLS-00201: identifier 'OIM_TYP_CHARARR' must be declared
ORA-06550: line 4, column 25:
PL/SQL: Item ignored
ORA-06550: line 5, column 18:
PLS-00201: identifier 'OIM_TYP_NUMBERARR' must be declared
ORA-06550: line 5, column 18:
PL/SQL: Item ignored
ORA-06550: line 179, column 14:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 177, column 9:
PL/SQL: SQL Statement ignored
ORA-06550: line 182, column 12:
PLS-00320: the declaration of the type of this expression is incomplete or
malformed
ORA-06550: line 182, column 9:
PL/SQL: Statement ignored
No errors.
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
please give me solution