Re: How launch a procedure with msdos batch ???

you need to have your batch login to sqlplus

navigate to the location of your sqlplus.exe file

then do

sqlplus username/password_at_instance

then exec procedure

if you want to run a function you can have it then call an anonymous block that you have in a .sql file
_at_file location

"jl" <jlargaud_at_ingesoft.fr> wrote in message news:acl44v$6h0$1_at_s1.read.news.oleane.net...
> Is somebody can help me ??
>
> J want to launch an Oracle procedure (without parameters) with a msdos
batch
> :
>
>
> cls
>
> echo lancement du script de transfert automatique >
> \\Is-srvnt4\e\testAlpaca\transfbat.log
>
> sqlplus -s alpaca kdoc/kdoc
> _at_D:\Tominge\Alpaca\version6.2\apl\PROCEDURES2.SQL
>
> REM sqlplus -s alpaca kdoc/kdoc _at_execute TRANS_AUTO
>
> echo execution terminee >> \\Is-srvnt4\e\testAlpaca\transfbat.log
>
> exit
>
>
> As it can be seen, J have tried to activate the file :
> _at_D:\Tominge\Alpaca\version6.2\apl\PROCEDURES2.SQL
> or the procedure : _at_execute TRANS_AUTO
>
> but it doesn't work...
>
> thanks to you
>
>
>
>
>
>
Received on Sun May 26 2002 - 03:09:28 CEST