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

  • From: rjamya <rjamya@xxxxxxxxx>
  • To: GMei@xxxxxx
  • Date: Wed, 31 May 2006 16:04:07 -0400

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
--
//www.freelists.org/webpage/oracle-l


Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2006