DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: oracle stored procedure with output parameter

  1. #11
    Join Date
    Oct 2000

    Re: Specify Output Parameter ....

    Is the procedure working? I think it is not, because in Ur "select ......." statement, U didn't specified any variable to hold that query result, I guess it is a problem, but I'm not pretty sure about that.

  2. #12
    Join Date
    Nov 1999
    Elbert, Colorado, USA
    It looks OK to me:

    SELECT pk_blockheader into v_id
    FROM callblockheader
    WHERE pk_blockheader =

    Apparently the compiler thought so too!

Posting Permissions

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

Click Here to Expand Forum to Full Width