PROCOBJ joke

From: Mladen Gogala <no_at_email.here.invalid>
Date: Tue, 24 Aug 2010 15:43:18 +0000 (UTC)
Message-ID: <pan.2010.08.24.15.43.18_at_email.here.invalid>

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','ADBASE')   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

Received on Tue Aug 24 2010 - 10:43:18 CDT