-
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.
-
I saw someone in the forum suggesting to put a / after the end; and it works.
