How launch a procedure with msdos batch ???

From: jl <jlargaud_at_ingesoft.fr>
Date: Fri, 24 May 2002 12:22:58 +0200
Message-ID: <acl44v$6h0$1_at_s1.read.news.oleane.net>



[Quoted] Is somebody can help me ??

J want to launch an Oracle procedure (without parameters) with a msdos batch :

cls

[Quoted] 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 Fri May 24 2002 - 12:22:58 CEST

Original text of this message