oracle create_program
BEGIN
-- PL/SQL Block.
DBMS_SCHEDULER.create_program (
program_name => 'test_plsql_block_prog',
program_type => 'PLSQL_BLOCK',
program_action => 'BEGIN my_job_proc(''CREATE_PROGRAM (BLOCK)'');
END;',
enabled => TRUE,
comments => 'CREATE_PROGRAM test using a PL/SQL block.');
END;