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: Alexei VORONOV <alexei_voronov_at_yahoo.com>
Date: Thu, 18 Oct 2001 14:17:00 +0200
Message-ID: <9qmh35$hgk$1@wanadoo.fr>


in NT you can launch the script with following lines:

exec <Your Proc>
/
exit
/

by using the next syntax:
sqlplus user/password @path_to_the_script

If it doesn't work in UNIX, verify sqlplus command line syntax

"Markus Neumaier" <markus.neumaier_at_rl-ag.de> a écrit dans le 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!!
>
>
Received on Thu Oct 18 2001 - 07:17:00 CDT

Original text of this message

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