Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010
    Posts
    3
    Rep Power
    0

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

  2. #2
    Join Date
    Mar 2010
    Posts
    3
    Rep Power
    0

    Default

    Small change in Line1:
    Line1: mCallableStatement = mConnection.prepareCall("{call BTKAPP.BTK_BATCH_JOBS_PKG.FETCH_BUG_DETAILS_FROM_L OG1(?)}");


    Pls let me know if you get any solution.

Similar Threads

  1. Replies: 2
    Last Post: 11-07-2012, 01:29 PM
  2. Class is public, should be declared in a file
    By goldhouse in forum New To Java
    Replies: 7
    Last Post: 05-10-2012, 09:17 AM
  3. Replies: 2
    Last Post: 12-05-2009, 11:24 AM
  4. Implicit object in jsp declared where?
    By mahendra.athneria in forum JavaServer Pages (JSP) and JSTL
    Replies: 7
    Last Post: 08-11-2009, 02:23 PM
  5. Replies: 5
    Last Post: 10-06-2008, 12:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •