SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Default value of parameter in stored procedure / function

632572May 26 2008 — edited May 26 2008

Hi all,

how to find out default value of parameter of stored function(I need it at runtime)?

SELECT * FROM ALL_ARGUMENTS .... doesn't contain value.

for example, piece of code from procedure:
I_S_SHORT_NAME IN VARCHAR2 DEFAULT NULL,
I_S_NATIONAL_ID IN VARCHAR2 DEFAULT 'EN',

text behind DEFAULT is important for me.

thx for any comments

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 23 2008

Added on May 26 2008

1 comment

471 views