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: Markus Neumaier <markus.neumaier_at_rl-ag.de>
Date: Fri, 19 Oct 2001 09:02:40 +0200
Message-ID: <9qoj67$pbec2$1@ID-113543.news.dfncis.de>


Your Call of SqlPlus application failed. It doesn't find the TNS-Listener. How could i set the tns-listner on startup sqlplus.

Best Regards Neimoa!!!

"Alexei VORONOV" <alexei_voronov_at_yahoo.com> schrieb im Newsbeitrag news:9qmh35$hgk$1_at_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 Fri Oct 19 2001 - 02:02:40 CDT

Original text of this message

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