Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2004
    Posts
    13

    Unanswered: How to call procedure with OUT value only

    Hi

    I am confused about calling a procedure with just OUT value into a normal variable.

    <varname> = CALL <procedure_name>;

    but its not working.

    Please tell me the right way to do this. I dont want to use a host variable for this.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    From the CLP you would call it like this:

    Call MyProc(?,?,?)

    assuming it had 3 out parameters.

    Andy

  3. #3
    Join Date
    Jun 2004
    Posts
    13
    Yeah whatever you said is the right way to invoke but if I use '?' then how will I make sure that I get the value of the procedure in which variable.

    I mean if my proc is myProc(?,?,?) and I have to store the OUT values in Var1, Var2 and Var3. How to do that?

    I think you got my question. Also I dont want to use any Host Variables.

  4. #4
    Join Date
    Jul 2004
    Posts
    76

    Here is the way

    Assume that you have one variable named out_var1 in which you want to store the value of out put parameter of the SP.

    Then make a call in following manner.

    call SP_NAME(out_var1);

Posting Permissions

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