Home » RDBMS Server » Server Administration » StoredProcedure
StoredProcedure [message #57700] Tue, 01 July 2003 03:55
rao
Messages: 25
Registered: July 1999
Junior Member
Dear Sir,

Using java i am connecting through oracle server to fetch the records of a stored procedures(using oracle thin driver). But when i am executing the procedure names SCOTT.DELETEBYDE, i am getting the error message as "

java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'SCOTT.DELETEBYDE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java) "

Could u please tell me how to declare the procedure using java.

Report message to a moderator

Previous Topic: How to recover the accidently dropped tables?
Next Topic: Maximum column name length??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 11:42:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.