Home » Developer & Programmer » JDeveloper, Java & XML » ORA-0650 Error !
ORA-0650 Error ! [message #92042] Mon, 16 February 2004 07:15 Go to next message
Madhavan Sundararajan
Messages: 2
Registered: February 2004
Junior Member
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.
Re: ORA-0650 Error ! [message #92049 is a reply to message #92042] Wed, 18 February 2004 23:15 Go to previous messageGo to next message
VS
Messages: 9
Registered: March 2000
Junior Member
Hi!! following is the description of the error u are getting. Take the appropriate action.
=======================================================
Cause: An attempt was made 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 do not 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.
Re: ORA-0650 Error ! [message #92068 is a reply to message #92042] Thu, 26 February 2004 07:38 Go to previous message
Dan White
Messages: 48
Registered: September 2003
Member
The reason you are getting this error is that the DBMS_PICKLER package is not avaliable in Oracle 7.x

The dbms_pickler package is invoket by the JDBC driver to convert the array to a byte stream so that Oralce can process it.
Previous Topic: Connecting to Oracle using Java API
Next Topic: connection status oracle jdbc.
Goto Forum:
  


Current Time: Wed Jul 28 21:41:39 CDT 2021