Oracle package params selection

#1

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.

#2

Ok. Got it. user_arguments http://www.psoug.org/reference/packages.html

On 17 Sie, 16:10, slafs <slaf... (AT) gmail (DOT) com> wrote:

Quote:

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.

#3

On Aug 17, 10:27*am, slafs <slaf... (AT) gmail (DOT) com> wrote:

Quote:

Ok. Got it. user_argumentshttp://www.psoug.org/reference/packages.html

On 17 Sie, 16:10, slafs <slaf... (AT) gmail (DOT) 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 --

#4

On 17 Sie, 18:13, Mark D Powell <Mark.Pow... (AT) eds (DOT) com> wrote:

Quote:

On Aug 17, 10:27*am, slafs <slaf... (AT) gmail (DOT) com> wrote:

Ok. Got it. user_argumentshttp://www.psoug.org/reference/packages.html

On 17 Sie, 16:10, slafs <slaf... (AT) gmail (DOT) 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 --

Thanks,

But I can't manipulate the desc results by select or something like
that, can I? This only (as You said) a quick reminder.

Regards

#5

On Aug 18, 4:43*am, slafs <slaf... (AT) gmail (DOT) com> wrote:

Quote:

On 17 Sie, 18:13, Mark D Powell <Mark.Pow... (AT) eds (DOT) com> wrote:

On Aug 17, 10:27*am, slafs <slaf... (AT) gmail (DOT) com> wrote:

Ok. Got it. user_argumentshttp://www.psoug.org/reference/packages.html

On 17 Sie, 16:10, slafs <slaf... (AT) gmail (DOT) 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 --

Thanks,

But I can't manipulate the desc results by select or something like
that, can I? This only (as You said) a quick reminder.

Regards- Hide quoted text -

- Show quoted text -

The SQLPlus describe command as in desc procedure would be useful say
when you are typing code in one window and need to verify the order or
spelling of the procedure parameters.

The all_arguments view can also be used by isn't as fast when you just
want to see the parameter list. It is however more useful for
creating listings of procedures with parameters and for use in
generating dynamic code.

HTH -- Mark D Powell --

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Oracle package params selection

comp.databases.oracle.misc comp.databases.oracle.misc

Oracle package params selection - 08-17-2009 , 09:10 AM

Re: Oracle package params selection - 08-17-2009 , 09:27 AM

Re: Oracle package params selection - 08-17-2009 , 11:13 AM

Re: Oracle package params selection - 08-18-2009 , 03:43 AM

Re: Oracle package params selection - 08-18-2009 , 08:52 AM