Oracle 11g ver 1
We have a daily backup job pulling and saving DDL for all objects in the development database using DBMS_METADATA.
All generated DDL's for the SCHEDULER objects are good except object's parameters
If JOB or PROGRAM has parameters then they are not retrieved
For example: program PGM1 has 8 defined parameters.
DBMS_METADATA.GET_DDL(OBJECT_TYPE=>'PROGRAM', NAME=>'PGM1')
returns only this
BEGIN
dbms_scheduler.create_program('"PGM1"','EXECUTABLE','/bin/find',8, FALSE);
COMMIT;
END;
I know, how to get program parameters via DBA_SCHEDULER_PROGRAM_ARGS and DBA_SCHEDULER_JOB_ARGS,
but this would require a big change in the backup process, so it is not an option.
Is it possible to get these parameters from DBMS_METADATA?
How to get values of all 8 parameters?
I was trying to execute DBMS_METADATA.GET_DEPENDENT_DDL(OBJECT_TYPE=>'????', BASE_OBJECT_NAME=>'PGM1'),
but what would be the object type?
I looked thru all Oracle DBMS_METADATA manuals and did a Google search but there is no details about GET_DEPENDENT_DDL object types