PLS-00302: component 'FETCH_BUG_DETAILS_FROM_LOG1' must be declared
Hi Folks,
Can anyone help me to resolve this issue pls? I have created a proc in a package in a schema. When I call this proc from java code, below exception is thrown.
java.sql.SQLException: ORA-06550: line 1, column 33:
PLS-00302: component 'FETCH_BUG_DETAILS_FROM_LOG1' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
I have created spec and body both. Both were compiled without any error.
Proc: FETCH_BUG_DETAILS_FROM_LOG1
Package: BTK_BATCH_JOBS_PKG
Schema: BTKAPP
Specification: PROCEDURE FETCH_BUG_DETAILS_FROM_LOG1(p_bugdetails_o OUT VARCHAR2);
Java Code:
Line1: mCallableStatement = mConnection.prepareCall("{call BTKAPP.BTK_BATCH_JOBS_PKG.FETCH_BUG_DETAILS_FROM_L OG1(?)}");
Line2: mCallableStatement.registerOutParameter(1, OracleTypes.VARCHAR);
Line3: mCallableStatement.execute();
In Line3, above exception is thrown.
But same java code is able to call existing procs and return the result. This problem happens only for new procs.