stored-proceduresparametersoracle10gsys

Are the stored procedures parameters in a sys table? (Oracle)

I need some meta data about my stored procedures. I know oracle stores meta information of its objects in sys tables.

systemtables

Does oracle store the parameter information of stored procedures? Like name, type and maybe description?

SYS.ALL_STORED_SETTINGS does not store this information. It only stores plsql meta parameter information.

Solution

  • Yes, in the ALL_ARGUMENTS view