Re: Run Stored Procedures from Shell!!!

From: Mathew <mathewgearon_at_hotmail.com>
Date: 18 Oct 2001 08:07:12 -0700
Message-ID: <cde46dbf.0110180707.4de15e08@posting.google.com>

"Markus Neumaier" <markus.neumaier_at_rl-ag.de> wrote in message news:<9qmc0b$p96ji$1_at_ID-113543.news.dfncis.de>...
> Hi,
>
> It is possible to start Stored Procedures from a normal Unix Shell Script.
> If it is possible, how?
>
> Best regards Neimoa!!

Do something like this in your unix script:

     sqlplus -s $SQLLOGIN << sqlend
     exec .....

sqlend

where $SQLLOGIN is your username/password_at_connectstring, and the 2nd sqlend must be in the 1st column. The "-s" option is a silent login. Hope this helps. Received on Thu Oct 18 2001 - 10:07:12 CDT