Results 1 to 2 of 2

Thread: find parameters

  1. #1
    Join Date
    Dec 2004
    Posts
    54

    Unanswered: find parameters

    Hi,

    I need to get output parameters from output of stored procedure.

    can anybody tell how can I do this?

    Thanks

  2. #2
    Join Date
    Aug 2004
    Location
    Rome, Italy
    Posts
    81
    hi allian,
    I invoke the pl/sql from a shell by sqlplus. So the only way to pass a parameter to the shell is the exit status which can be from 0 to 255. If you want to get more than one output parameters is better to display them on screen with DBMS_OUTPUT.PUT_LINE(par1||' '||par2) and pipe this output to awk for manipulation. Another way it could be writing to a file and treating the file after.

    I hope it helps,
    ducasio

Posting Permissions

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