Hi,

Can anyone tell me how to execute a function declared in Oracle Package from Unix shell script?

I created a shell script and after connecting to oracle database i am using
exec @ Db_name.Package name.function_n ame('p1','P2');

and after executing the shell scripts i am getting the follwing error:-ERROR at line 13:
ORA-06550: line 13, column 2:
PLS-00221: 'function_name' is not a procedure...