Database Administration (MOSC)

MOSC Banner

how to get list of arguments in a procedure with DEFAULT VALUE

edited Oct 9, 2013 11:05AM in Database Administration (MOSC) 4 commentsAnswered
I want to get list of arguments in a procedure with DEFAULT VALUE .

For instance:

DBMS_METADATA.GET_DDL (
object_type     IN VARCHAR2,
name            IN VARCHAR2,
schema          IN VARCHAR2 DEFAULT NULL,
version         IN VARCHAR2 DEFAULT 'COMPATIBLE',
model           IN VARCHAR2 DEFAULT 'ORACLE',
transform       IN VARCHAR2 DEFAULT 'DDL')
RETURN CLOB;

1.we have dba_source but TEXT shows a huge list.........not specific to just GET_DDL

2.i checked dba_arguments but doesnt show the default value:

SQL> select OWNER,OBJECT_NAME,PACKAGE_NAME,ARGUMENT_NAME,DATA_TYPE,DEFAULTED,DEFAULT_VALUE,IN_OUT from dba_arguments where OBJECT_NAME='GET_DDL' and PACKAGE_NAME='DBMS_METADATA';OWNER OBJECT_NAME PACKAGE_NAME ARGUMENT_NAME DATA_TYPE D DEFAULT_VA IN_OUT----- ------------------------------ ------------------------------ ------------------------------ ------------------------------ - ---------- ---------SYS GET_DDL DBMS_METADATA TRANSFORM VARCHAR2 Y INSYS GET_DDL DBMS_METADATA MODEL VARCHAR2 Y INSYS GET_DDL DBMS_METADATA VERSION VARCHAR2 Y INSYS GET_DDL DBMS_METADATA SCHEMA VARCHAR2 Y INSYS GET_DDL DBMS_METADATA NAME VARCHAR2 N INSYS GET_DDL DBMS_METADATA OBJECT_TYPE VARCHAR2 N INSYS GET_DDL DBMS_METADATA CLOB N OUT7 rows selected.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center