We can execute the unix command from oracle10g procedure

Question

Oracle10g on a unix machine

I have a requirement to execute a unix command in a procedure, how can I do this?

Answer 1

BEGIN
     DBMS_SCHEDULER.create_job(
    job_name        => 'SHELL_JOB',
    repeat_interval  => 'FREQ=DAILY; BYHOUR=2',
    job_type         => 'EXECUTABLE',
    job_action       => '/u01/app/oracle/admin/tools/shell_job.sh',
    enabled          => TRUE,
    comments         => 'Perform stuff'
);
END;

Answer 2

You can use Oracle DBMS_SCHEDULER package . There is also an open source package package for this. You can find these here .

Answer 3

DBMS_SCHEDULER, PL/SQL, .

Answer 4

. - os SQL PL/SQL. :

() Oracle PL/SQL: -

, , SQL * Loader SQL:

Oracle SQL-Loader SQL PL/SQL

, - Python. Python Linux ( Oracle Linux), , Windows, python 2.7.3