053-451

Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?
A. PLSQL_BLOCK
B. JAVA_STORED_PROCEDURE
C. STORED_PROCEDURE
D. EXECUTABLE
E. None of the above are invalid settings.

  Java stored procedures cannot be executed by the job Scheduler unless they are called from within a PL/SQL procedure wrapper.This can be done in a stored procedure using PL/SQL's Extenal Procedure feature.Therefore,the job or program type setting would be STORED_PROCEDURE.

posted @ 2017-11-14 17:13  巴啦啦大魔王  阅读(87)  评论(0编辑  收藏  举报