Re: can we call unix scripts from oracle database

From: Nigel Thomas <nigel_cl_thomas_at_yahoo.com>
Date: Fri, 30 Mar 2007 01:51:01 -0700 (PDT)
Message-ID: <288805.86975.qm@web58711.mail.re1.yahoo.com>

Edwin

>> Does anyone know how to call unix scripts from oracle database?

See Ask Tom: http://asktom.oracle.com/pls/asktom/f?p=100:11:121647670368872::::P11_QUESTION_ID:952229840241

It's a long running thread - there are different answers for different Oracle versions.

In 10g you can use DBMS_SCHEDULER (see eg DBMS_SCHEDULER.CREATE_JOB( ... job_type=>'EXECUTABLE', job_action=>'myscript my argument list', ...)

http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_sched.htm#i1000363

Regards Nigel

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Mar 30 2007 - 03:51:01 CDT