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 -> Re: stored proc parameter on oracle 7

Re: stored proc parameter on oracle 7

From: Terry Dykstra <dontreply_tddykstra_at_forestoil.ca.x>
Date: Tue, 04 Nov 2003 17:39:39 GMT
Message-ID: <vvRpb.120770$EO3.79904@clgrps13>


Doesn't all_arguments show you that?

-- 
Terry Dykstra
Canadian Forest Oil Ltd.
"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
news:3FA7DBF3.107FF1D_at_remove_spam.peasland.com...

> I don't have a Oracle 7 version to play with, but can't you do a
> "DESCRIBE proc_name" in SQL*Plus to get a list of the procs parameters?
>
> HTH,
> Brian
>
>
>
> "@rennes" wrote:
> >
> > How can i have the parameter of a stored proc on oracle 7 ?
> > Are there a view or a table, where is it ?
>
> --
> ===================================================================
>
> Brian Peasland
> dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Tue Nov 04 2003 - 11:39:39 CST

Original text of this message

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