How to capture the return value of the oracle function in shell script
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to capture the return value of the oracle function in shell script

  1. #1
    Join Date
    Aug 2002
    Posts
    3

    How to capture the return value of the oracle function in shell script

    I have a shell script like this:

    sqlplus -s $USER/$PASS << ENDSQL #1> /dev/null 2>&1
    set define off
    set head off
    whenever sqlerror exit sql.sqlcode
    select fn_get_current_date_for_region('USA') from dual; ENDSQL

    I want to capture the return value of the oracle function fn_get_current_date_for_region('USA') in the shell script. How can i do this?
    Thanks...

  2. #2
    Join Date
    Nov 2002
    Posts
    80
    spool?

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