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 -> Re: Enumerating stored procedures & their columns

Re: Enumerating stored procedures & their columns

From: Dan Morgan <dmorgan_at_exesolutions.com>
Date: Wed, 11 Nov 1998 11:16:32 -0800
Message-ID: <3649E290.17262F22@exesolutions.com> 





> I'm trying to enumerate all the stores procedures under a particular schema


> CT3 in a database CT1, which is not the default database, using the


> getProcedures method of databasemetadata in a JDBC program.





Why not just perform a select from dba_objects where object_type = 'PROCEDURE'
and owner = 'CT3'?



Daniel A. Morgan

Received on Wed Nov 11 1998 - 13:16:32 CST












Original text of this message













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