Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Is Package Information Stored in an ALL_* Table?

Is Package Information Stored in an ALL_* Table?

From: Brian Y. <NOSP_at_M>
Date: Tue, 23 Jan 2001 01:26:14 GMT
Message-ID: <W45b6.3843$mo2.443408@news1.news.adelphia.net> 






I would like to query the database for package information - namely the
names of all the functions or procedures that are part of my package
definition.



For example, if I have a package...



CREATE PACKAGE PKG1 AS...


PROCEDURE update_names (...


PROCEDURE update_appointments (...


FUNCTION get_order_date (...


etc.


END PKG1;


I would like to query for...


update_names


update_appointments


get_order_date


etc.



Is there an ALL_ table that stores this information? Thanks in advance...



B~
Received on Mon Jan 22 2001 - 19:26:14 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US