oracle stored procedure with output parameter - Page 2
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
    Posts
    123

    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
    Location
    Elbert, Colorado, USA
    Posts
    81
    It looks OK to me:

    SELECT pk_blockheader into v_id
    FROM callblockheader
    WHERE pk_blockheader =
    CallBlockHeader_Seq.currval;

    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