ORA-06550 Error !!
414877Feb 13 2004 — edited Aug 12 2004I need to port the data from Oracle 9i to Oracle 7. I fetch the records from Oracle 9i. Now I need to invoke a store procedure present in Oracle 7, passing the fetched values as array objects. This procedure will insert into the respective tables with the values I pass from Java JDBC code.
I am facing problems when I mask them in an "oracle.sql.ARRAY" object. I get the following error :
SQL Exception from class com.hollywood.transformation.Transformer getCallableStatement method java.sql.SQLException: ORA
-06550: line 1, column 13:
PLS-00201: identifier 'DBMS_PICKLER.GET_TYPE_SHAPE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06550: line 1, column 73:
PLS-00201: identifier 'DBMS_PICKLER.GET_FORMAT' must be declared
ORA-06550: line 1, column 67:
PL/SQL: Statement ignored
If anybody have come across this problem kindly help me out.