I have a requirement to execute a perl script from a PL/SQL script. The perl script executes various system com开发者_如何学Pythonmands, and this piece is already developed. The piece I am having trouble with is executing the perl script from the PL/SQL code. Can someone help me with this?
Execute it as DBMS_SCHEDULER job with job_type => 'EXECUTABLE'.
This specifies that the job is a job external to the database. External jobs are anything that can be executed from the operating system's command line.
Details are described in Oracle's documentation for DBMS_SCHEDULER.CREATE_JOB
精彩评论