Executing a function declared in Oracle Package from Unix shell script:-

[gagandutta01]

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.Packagename.function_name('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 or is undefined
ORA-06550: line 13, column 2:
PL/SQL: Statement ignored


Can anyone help me out as how to execute a function?
Your suggestion will be Highly appreciated.

[Motoma]

I have bumped this thread over to the Oracle forum, as I feel this is more related to the use of Oracle and it's specific tools than Unix.

[amitpatel66]

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.Packagename.function_name('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 or is undefined
ORA-06550: line 13, column 2:
PL/SQL: Statement ignored


Can anyone help me out as how to execute a function?
Your suggestion will be Highly appreciated.

When executing a procedure, just say EXEC dbname.package.function_name(<parameters>);
@ is not required.

The error says function_name is not a procedure or undefined.
Could you please POST your package/package body for my reference.
It seems that the procedure/function with name function_name is not defined in a package or under db_name!!