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.
|
|
|