OraFAQ Forum: Server Utilities » Submitting an Oracle 8i stored procedure from asn MS DOS batch file

Home » RDBMS Server » Server Utilities » Submitting an Oracle 8i stored procedure from asn MS DOS batch file

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Submitting an Oracle 8i stored procedure from asn MS DOS batch file [message #73025]

Mon, 19 January 2004 03:18

Mike Kiehn
Messages: 1
Registered: January 2004

Junior Member

�

Hi,� I would like to execute a SQL delete statement against an Oracle 8i database from the Tivoli Maestro scheduling tool.� Abviously I have to handle the return codes etc...� Any ideas?

Report message to a moderator

Re: Submitting an Oracle 8i stored procedure from asn MS DOS batch file [message #73030 is a reply to message #73025]

Tue, 20 January 2004 01:51

Frank Naude
Messages: 4580
Registered: April 1998

Senior Member

Hi,

You can call sqlplus from the DOS command line (or a *.BAT or *.CMD file). Example:

C:>sqlplus scott/tiger@orcl
SQL> exit 99

C:>ECHO %errorlevel%
99

Also see -
http://www.orafaq.com/faqwinnt.htm#commands
http://www.orafaq.com/faqwinnt.htm#schedule

Best regards.

Frank

Report message to a moderator

Previous Topic:	Loading Big files through SQL Loader
Next Topic:	SQL Ldr

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 27 22:26:54 CDT 2024