Home » RDBMS Server » Server Administration » ORA-0650 error
ORA-0650 error [message #60429] Sat, 07 February 2004 04:34 Go to next message
Tally
Messages: 3
Registered: January 2004
Junior Member
Hi

When i try to invoke a Oracle 9i Stored procedure('COMM.TRANCHE_ENQUEUE_MSG' ) from java i am getting the following error

Message:

java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'COMM.TRANCHE_ENQUEUE_MSG' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

 

What could be wrong?

Any Help is appreciated

 
Re: ORA-0650 error [message #60512 is a reply to message #60429] Wed, 11 February 2004 09:52 Go to previous message
ilver
Messages: 50
Registered: January 2004
Member
Hi,
You need to give a little more information on what you try to do, not just the error message.
You have to remember that you define/declare a java stored procedure by making some jave code and then encapsulate it in to a fx. PLSQL function body.
/ilver
Previous Topic: partition table
Next Topic: TUNE QUERY
Goto Forum:
  


Current Time: Fri Sep 20 10:26:05 CDT 2024