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.