Unix Script

[lesstjm]

I am writing a unix script that runs a function in the database by logging in and calling the function. I am not able to get the return value from the function. This is what I have and it is not working:

num=`sqlplus -s << EOSQL
${USER}/${PASSWORD}
set serveroutput on
declare
x number;
begin
x := UPD_FUNC(0000046,'F');
dbms_output.put_line(x);
end;
EOSQL
`

the function works fine from the command line. Any ideas?
We are using AIX unix with oracle 8.1.7.

[kris109]

I saw someone in the forum suggesting to put a / after the end; and it works.