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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: how to get function/procedure name and type in a package

Re: how to get function/procedure name and type in a package

From: rjamya <rjamya_at_gmail.com>
Date: Wed, 31 May 2006 16:04:07 -0400
Message-ID: <9177895d0605311304i6322872egfec2691e5de0a1d4@mail.gmail.com>


you can check all_arguments

 if for a given object_name in a given package_name if there is an argument at position 0 then it is a function otherwise it is a procedure.

there is a neat decode that I submitted to OTN few months ago, but can't locate it.

Raj

--
http://www.freelists.org/webpage/oracle-l
Received on Wed May 31 2006 - 15:04:07 CDT

Original text of this message

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