I recently had to do some export/import things and one of my jobs failed
to re-create. That, in itself, is not the problem. The problem is the
fact that the official documentation for DBMS_METADATA lists type "JOB"
as the type to use when recreating objects while that doesn't really work:

SQL> select dbms_metadata.get_ddl('JOB','TV_COST_REQ_JOB','ADB ASE')
2 from dual;
ERROR:
ORA-31604: invalid NAME parameter "NAME" for object type JOB in function
SET_FILTER
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 116
ORA-06512: at "SYS.DBMS_METADATA_INT", line 4727
ORA-06512: at "SYS.DBMS_METADATA_INT", line 8334
ORA-06512: at "SYS.DBMS_METADATA", line 3305
ORA-06512: at "SYS.DBMS_METADATA", line 3091
ORA-06512: at "SYS.DBMS_METADATA", line 4787
ORA-06512: at line 1



no rows selected

Elapsed: 00:00:00.13

If I substitute "PROCOBJ" for the object type parameter, all is well:

SQL> select dbms_metadata.get_ddl('PROCOBJ','TV_COST_REQ_JOB', 'ADBASE')
2 from dual;

DBMS_METADATA.GET_DDL('PROCOBJ','TV_COST_REQ_JOB', 'ADBASE')
--------------------------------------------------------------------------------


BEGIN
dbms_scheduler.create_job('"TV_COST_REQ_JOB"',
job_type=>'STORED_PROC


Elapsed: 00:00:00.21
SQL>


Of course, I would like more details, like schedule, but this is good,
too. The problem is that this "PROCOBJ" thing is not documented anywhere.
Has anyone tried RDBMS 11.2? Is there stil a "PROCOBJ" or "JOB"? I'll try
later.

--
http://mgogala.byethost5.com