dbms_metadata.GET_DDL for all procedures for a schema
834783Dec 5 2011 — edited Dec 5 2011I am trying to capture all the procedure DDLs for schema CUSTOM
I am using 11g on Linux.
I run this command...
SELECT dbms_metadata.GET_DDL('PROCEDURE',NULL,'CUSTOM') FROM DUAL;
And get this error:
ORA-31600: invalid input value NULL for parameter VALUE in function SET_FILTER
ORA-06512: at "SYS.DBMS_METADATA", line 4018
ORA-06512: at "SYS.DBMS_METADATA", line 5843
ORA-06512: at line 1
Thanks in advance.