Get value out of PL/SQL in shell script
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Get value out of PL/SQL in shell script

  1. #1
    Join Date
    Feb 2003
    Posts
    1

    Get value out of PL/SQL in shell script

    When i run this under shell script :

    sqlplus -s dcp_owner/mal_dcp_o@maldev @Call_Path.txt $ret_val
    v_tmp = $ret_val
    echo v_tmp


    Call_Path.txt contains the sql script.
    No output for v_tmp.
    if i change it to :
    sqlplus -s dcp_owner/mal_dcp_o@maldev @Call_Path.txt $ret_val >$File
    I can see the data exists on the File .
    But i get the v_tmp.
    May i know what is going on?

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    try something like:
    Code:
    v_tmp = `sqlplus -s dcp_owner/mal_dcp_o@maldev @Call_Path.txt`
    echo $v_tmp
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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