Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Run Stored Procedures from Shell!!!

Re: Run Stored Procedures from Shell!!!

From: Andreas Stephan <as.stedat_at_gmx.net>
Date: Thu, 18 Oct 2001 14:08:19 +0200
Message-ID: <9qmgke$oev10@byz672.bayer-ag.com>


Hi Markus,

you can only do such things using embedded sql (PRO*C etc.) or calling sqlplus with a script as argument (eg. sqlplus user/pw_at_instance @script_file.pls). In this script you can call the stored procedure/package/function as well as doing sql.

hth
Andy

"Markus Neumaier" <markus.neumaier_at_rl-ag.de> schrieb im Newsbeitrag 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!!
>
>
Received on Thu Oct 18 2001 - 07:08:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US