Which table or view keep function or procedure name of any package?

Not that I'm aware of. Which version of database and SQL*Plus (or whatever tool you are using for DESCRIBE command) are you using? At least on 8.1.7 and above, even SQL*Plus's DESCRIBE doesn't show any packaged variables or constants. I suspect you are using some very old release of SQL*Plus if you get the output of the DESCRIBE command in the format you provided.

AFAIK, only packaged procedures and functions (and their arguments) are included in ALL_/USER_ARGUMENTS - no global variables, constants, types etc... So I have no idea where could one get theose, appart from looking at the source (*_SOURCE view).

And BTW, Sameer, why do you join ALL_ARGUMENTS to ALL_OBJECTS? I think your query will not return anything, as OBJECT_NAME in ALL_ARGUMENTS holds packaged function/procedure names, which on the other hand do not exist in ALL_OBJECTS, because those are not standalone objects! So unless you have created standalone functions/procedures that have the same names as packaged functions/procedures your query will return nothing. Or am I wrong?

Quote:

---

Originally posted by jmodic

And BTW, Sameer, why do you join ALL_ARGUMENTS to ALL_OBJECTS? I think your query will not return anything, as OBJECT_NAME in ALL_ARGUMENTS holds packaged function/procedure names, which on the other hand do not exist in ALL_OBJECTS, because those are not standalone objects! So unless you have created standalone functions/procedures that have the same names as packaged functions/procedures your query will return nothing. Or am I wrong?

---

Thanks for correction. I joined USER_ARGUMENTS to USER_OBJECTS. It skip from my mind that it doesn't store information for procedure/functions inside the packages as those are not stand alone objects, so USER_OBJECTS won't get any record for that. Sorry about that :-(

How can you be wrong :)

Sameer