SQL & PL/SQL

Hi all,

I'm writing a Generator which reads the Definition of Procedures from certain Packages out of the Database and then generates some Code out of the read Interface definition.

This really works good for me, the only thing I'm missing is the Default Value for defaulted Parameters.

e.g.: PROCEDURE Rag_Test ( p_parameter_1 IN NUMBER := 15 );

I get all Informations out of some Data Dictionary Tables (sys.obj$, sys.argument$, ...) but not the default value.

In sys.argument$ are some columns where I thought the value is, but DEFLENGTH and DEFAULT$ are empty, just DEFAULT# is set to 1 if the Parameter is defaulted.

Do you have any Idea where I can get the Default value from ?

thanks,

Peter