stored procedure [message #3086] |
Wed, 04 September 2002 02:15 |
lacade
Messages: 1 Registered: September 2002
|
Junior Member |
|
|
hi,
how can i run a stored procedure from a unix script.
thanks
|
|
|
Re: stored procedure [message #3088 is a reply to message #3086] |
Wed, 04 September 2002 03:02 |
Keith
Messages: 88 Registered: March 2000
|
Member |
|
|
myfile.sh:
#!/bin/ksh
sqlplus scott/tiger@test @myfile.sql
myfile.sql:
exec my_stored_proc;
exit;
Make sure you have sqlplus in the path for the UNIX user executing the script, and that the user you connect to sqlplus as can see/execute the strored procedure.
|
|
|