Re: Run Stored Procedures from Shell!!!

From: Alexei VORONOV <alexei_voronov_at_yahoo.com>
Date: Fri, 19 Oct 2001 09:37:02 +0200
Message-ID: <9qol3n$naj$1@wanadoo.fr>

Sorry I forgot intance in command line

sqlplus user/password_at_INSTANCE @path_to_the_script

This will probably work (in NT does)

"Markus Neumaier" <markus.neumaier_at_rl-ag.de> a écrit dans le message news: 9qoj67$pbec2$1_at_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:37:02 CDT