Calling an Oracle Stored Procedure from Unix shell script

Shell Programming and Scripting
1

hai,

 can anybody say how to call or to execute an oracle stored procedure in oracle from unix...

thanks in advance.... for ur reply....

by,
leo

2

Please search forums for oft repeated questions. Here is a link.

3

hi
it is pretty easy to call procedure from unix

go to vi-editor

#!/bin/sh

sqlplus -s username/password<<END
execute procedure_name( parameters,....)
Commit;
exit;
END


eg:

sqlplus -s scott@dbase/tiger<<END
execute test_proc(132,'raj');
commit;
exit;
END

after this save and exit from editor
and run in from the uix prompt... sh sciptname

it will work..