Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-06550 Error !!

414877Feb 13 2004 — edited Aug 12 2004
I 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2004
Added on Feb 13 2004
6 comments
846 views