Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2004
    Posts
    15

    Unhappy Unanswered: PLS-00227: subprogram 'in' formal INTSTATUS is not yet denotable

    Dear all,

    I have a procedure and which needs some arguments to be passed to it, when the procedure is compiled i got the following exception

    LINE/COLUMN : 81/5
    Error Description : PLS-00227: subprogram 'in' formal INTSTATUS is not yet denotable

    On the specified line no: 81, we have an IF check with the parameters passed, here the "INTSTATUS" is one of the parameters passed to the procedure. and also note that the INTSTATUS is used only in the line 81 after it is defined in the parameter list of the procedure.
    the line appears very similar as the following,
    Create proc proce1(INTSTATUS IN NUMBER DEFAULT NULL, PARAM1 ...., PARAM2 .... .... )
    :
    :
    :
    Line NO: 81> IF INTSTATUS = 1 OR param2 <> param3

    In the net I got the following definition, for the error PLS - 00227

    EXPLANATION FOR THE ERROR I GOT IN THE NET:
    ------------------------------------------------------------------

    PLS-00227: subprogram IN formal name is not yet denoteable

    Cause: When the formal parameters of a subprogram were declared, one parameter was used to initialize another, as in

    PROCEDURE my_proc (j NUMBER, k NUMBER := j) IS ...


    The first parameter has no value until run time, so it cannot be used to initialize another parameter.

    Action: Remove the illegal formal parameter reference.
    ----------------------------------------------------------------------------------------------------------------------------------

    but here I have not tried to initialize the parameter with unknown value
    pls clarify me how can i overcome this exception

    any help on this will be appreciated

    Thanks
    Sathya V
    Last edited by sathyav; 10-12-04 at 13:16.

  2. #2
    Join Date
    Apr 2004
    Posts
    246
    you didn't specify the datatype of the variable. do that first, then see if the error goes away (oracle is notorius for misleading you because it can't decide which is the real error).
    Give a man a fish, you feed him for a day. Club him over the head with a fish, he'll leave you alone.

  3. #3
    Join Date
    Oct 2004
    Posts
    15
    I ve missed out the data type in this post
    that parameter is declared as NUMBER type in the procedure

  4. #4
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Post your real code, so we can see it - the whole procedure.

  5. #5
    Join Date
    Oct 2004
    Posts
    15
    I found the reason for the exception, Thanks for all your efforts


    Cheers
    Sathya V

Posting Permissions

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