Re: calling pl/sql function from unix shell script

Play around
sqlplus variable, exit commands
select ... into statements

You should write something like following

CONNSTR="SCOTT/TIGER"
SQLSTR="select to_number(to_char(sysdate,'SSSSS')) into :excode from dual;" sqlplus $CONNSTR <<EOF
variable excode number
$SQLSTR
exit :excode
EOF PS: AFAIK you can't return date as returning code in Unix, it should be integer

"Patrick" <P_swiggers_at_yahoo.com> wrote in message news:3b58c6c3.0112110940.3f5e71f2_at_posting.google.com...
> I want to call a pl/sql function from a unix shell script and get the
> return value. This is how I use sql from within a script:
> SQL_STR="select sysdate from dual;"
> echo ${SQL_STR} | sql
> echo $?
> How can I do the same thing but calling a pl/sql function and getting
> the returned value?
Received on Tue Dec 11 2001 - 13:47:55 CST