Results 1 to 3 of 3
  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
    sethnakola is offline Member
    Join Date
    Nov 2012
    Posts
    1
    Rep Power
    0

    Default Re: PLS-00302: component 'FETCH_BUG_DETAILS_FROM_LOG1' must be declared

    Hi

    If your procedure is under package check spec part whether procedure is declared or not.

    sethna

  3. #3
    DarrylBurke's Avatar
    DarrylBurke is offline Member
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,235
    Rep Power
    19

    Default Re: PLS-00302: component 'FETCH_BUG_DETAILS_FROM_LOG1' must be declared

    Please don't post in long dead threads. Did you really think someone would still be waiting for an answer well over two years later?

    db

    THREAD CLOSED
    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

Similar Threads

  1. 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
  2. Replies: 2
    Last Post: 12-05-2009, 11:24 AM
  3. Replies: 7
    Last Post: 11-09-2009, 07:51 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
  •