CODEWITHSUNDEEP
oracle-databasebatch-fileplsqlcmd
lightweight
lightweight

Reputation: 3327

execute a windows cmd line from PL/SQL

I'm fairly new to the oracle environment (but am extremely familiar with SQL Server) and am trying to figure out how to launh a windows CMD line at the end of my PL/SQL procedure. Any ideas on how to do this?

Upvotes: 1

Views: 3444

Answers (1)

David Aldridge
David Aldridge

Reputation: 52386

DBMS_Scheduler can run a .bat file. See "job_type" and "job_action" in the docs: http://docs.oracle.com/cd/E11882_01/appdev.112/e16760/d_sched.htm

Equally well, Oracle can send an email of course: http://docs.oracle.com/cd/E11882_01/appdev.112/e16760/u_mail.htm#i1001258

Upvotes: 3

Related Questions