Re: PROCEDURE arguments & defaults (data dictionary views)

Hello Michel,

> | According to the documentation, ALL_ARGUMENTS holds the
> | available parameters for procedures.
> |
> | It has two columns for DEFAULTs - but they are "reserved for
> | future use".
> |
> | However, the DEFAULT clause is supported when creating a
> | procedure.
> |
> | Where does this information get stored, besides ALL_SOURCE?
>
> The first time i heard this question it was in 1993.
> The answer is still the same for every Oracle version from 7 to 10g:
> to get the default values parse the source.

Well, thanks for the confirmation - that's what I'm doing now :-)

Strange though...

-- 
With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com