HOST ('<your path and filename here>');

E.g.

HOST ('c:\myfile.bat');


Please note however the SQL script will not wait for a response from the
host call. It simply invokes it and continues with processing.

-----Original Message-----
From: VGaddipati
[mailto:oracledba-ezmlmshield-x68155500.[Email address protected]
Sent: Wednesday, July 06, 2005 2:00 PM
To: LazyDBA Discussion
Subject: Running batch job from sql script !!


Greetings,

Can somebody show me how to run a windows batch file from within sql
script.

Thanks in advance.



Kind Regards,
Venugopal R.
Technical Architect (Database).


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

*** Confidentiality Notice *** Proprietary/Confidential
Information belonging to CGI Group Inc. and its affiliates
may be contained in this message. If you are not a recipient
indicated or intended in this message (or responsible for
delivery of this message to such person), or you think for
any reason that this message may have been addressed to you
in error, you may not use or copy or deliver this message
to anyone else. In such case, you should destroy this
message and are asked to notify the sender by reply email.

Oracle LazyDBA home page