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

[suwatchai_s]

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

Example

SQL> desc dbms_alert
Element Type
------------ ---------
MAXWAIT CONSTANT
SET_DEFAULTS PROCEDURE
REGISTER PROCEDURE
REMOVE PROCEDURE
REMOVEALL PROCEDURE
WAITANY PROCEDURE
WAITONE PROCEDURE
SIGNAL PROCEDURE

the name of element i want

[Kumar_RP]

select object_name from obj
where object_type in('PROCEDURE','FUNCTION', 'PACKAGE');

Hope this resolve your problem.

[suwatchai_s]

thank you. Mr.Kumar_RP

but it 's not that i want.
which table can show subpackage to me.
such as i describe package. it show subpackage.

[Kumar_RP]

Hi,
Do you want to see the script of the Package / Function / Procedure ?.

[suwatchai_s]

thanks,
no,i don't.
I would like to select object_name,parameter name,data type and return datatype (if function) of package. which view can i select?

[jmodic]

SELECT
  object_name AS element,
  DECODE(MIN(position), 0, 'FUNCTION', 'PROCEDURE') AS type
FROM all_arguments
WHERE package_name = 'DBMS_ALERT' AND owner = 'SYS'
GROUP BY object_name;

[Sameer]

SELECT a.object_name, argument_name, data_type,
       CASE
          WHEN (object_type = 'FUNCTION' AND in_out = 'OUT') THEN 'RETURN'
          ELSE in_out
       END CASE
FROM user_arguments a, user_objects b
WHERE a.object_name = b.object_name;

[Kumar_RP]

Hi,
You can your details by DESCRIBE right?.

Ex.
My procedure name is WHO_CALLED_ME;

SQL> describe WHO_CALLED_ME;
PROCEDURE WHO_CALLED_ME
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
OWNER VARCHAR2 OUT
NAME VARCHAR2 OUT
LINENO NUMBER OUT
CALLER_T VARCHAR2 OUT


Is it ok for you?>>

[suwatchai_s]

thank you. mr.jmodic and mr.Sameer, that i want.
and thank you mr.Kumar_RP for your suggest.

[suwatchai_s]

I have more question. Can i find constant or variable?

SQL> desc dbms_alert
Element Type
------------ ---------
MAXWAIT CONSTANT
SET_DEFAULTS PROCEDURE
REGISTER PROCEDURE
REMOVE PROCEDURE
REMOVEALL PROCEDURE
WAITANY PROCEDURE
WAITONE PROCEDURE
SIGNAL PROCEDURE