Calling procedure from Shell script
How to call a stored procedure from shell script and vice-versa?
I think its like calling a sql batch program.
sqlplus system/manager @batch1.sql
I think u can not do the reverse...u may opt to use
scheduler or crontab to call the shell script.
Am i right davey or partly
Last edited by yxez; 09-12-2006 at 05:01 AM.
You can combine the shell script and the sql script into a single shell script. I assume in the example that oraenv is in /usr/local/bin. On some UNIX platforms it's located elsewhere
To call a shell script from a stored procedure your looking at Java in the database on external procedures in C or similar.
# Set up the oracle environment
sqlplus username/password <<EOF
Click Here to Expand Forum to Full Width