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 -> how do I retrieve the function body of a user function thru SQL

how do I retrieve the function body of a user function thru SQL

From: Jerwynn <venture_at_i-manila.com.ph>
Date: Mon, 24 May 1999 18:49:26 +0800
Message-ID: <37492EB6.7FD2873C@i-manila.com.ph> 





Hi,



Is there any way I can see the declaration of a stored user function or
procedure


by querying tables in Oracle catalog?



What tables store information about stored procedures, functions, and
packages?



Likewise, I have some problems with "create function" script
SQL plus shows a warning message saying there were compilation errors...



how do i know what specific error occurred?




Thanks,



Jerwynn

Received on Mon May 24 1999 - 05:49:26 CDT












Original text of this message













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