Oracle - Pass Parameters from shell script to stored procedures
Posted on 2007-07-26
I am producing two parameters from a webpage (jsp,java) and am sending them to a shell script.
I want to call them in a stored procedure from the shell script as below:
sqlplus $USERNAME @/opt/sql/removehols_sql $1 $2 <---- calling params correctly?
The "removehols_sql" then calls the actual procedure that utilises the parameters:
call full_removehols(); <---------- how do I pass the parameters from "removehols_sql"?
If I hardcode in parameters it works fine
can somebody please tell me how I can pass the parameters through corectly as this is quite urgent.