Re: Oracle package params selection

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Mon, 17 Aug 2009 09:13:27 -0700 (PDT)
Message-ID: <9a92aedc-7a70-4aaa-b3e5-55f678aaac6a_at_a13g2000yqc.googlegroups.com>

On Aug 17, 10:27 am, slafs <slaf..._at_gmail.com> wrote:
> Ok. Got it. user_argumentshttp://www.psoug.org/reference/packages.html
>
> On 17 Sie, 16:10, slafs <slaf..._at_gmail.com> wrote:
>
>
>
> > Hi!
>
> > I was wondering if I can select somehow parameters of a function,
> > procedure (inside a package or standalone) other than parsing the
> > dba_source view?
>
> > Thanks in advance.
> > Regards.- Hide quoted text -
>
> - Show quoted text -

You can also use describe in SQLPlus to see procedure parameters lists as well as packaged procedure parameter lists when you just need a quick reminder.

HTH -- Mark D Powell -- Received on Mon Aug 17 2009 - 11:13:27 CDT