soulshaper
Member
Hi,
this one is slightly offtopic.
PL/SQL Developer shows the procedures/functions including respective parameters in the treeview. How do you achieve that? What kind of data dictionary view do I have to query to find out which functions/procedures are defined in packages (db wide) and which parameters they use.
I know one can do that by querying all_objects (object_type='PROCEDURE' or 'FUNCTION') but they don't include procedures/functions which are defined in the packages header.
Could you tell please how you solved that one in PL/SQL Developer? Which view do I have to query for that? What additional parsing is needed? Don't tell me that all_source is the one ;-)
Thanks in advance. Readya.
this one is slightly offtopic.
PL/SQL Developer shows the procedures/functions including respective parameters in the treeview. How do you achieve that? What kind of data dictionary view do I have to query to find out which functions/procedures are defined in packages (db wide) and which parameters they use.
I know one can do that by querying all_objects (object_type='PROCEDURE' or 'FUNCTION') but they don't include procedures/functions which are defined in the packages header.
Could you tell please how you solved that one in PL/SQL Developer? Which view do I have to query for that? What additional parsing is needed? Don't tell me that all_source is the one ;-)
Thanks in advance. Readya.
