Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help With procedures....
thanks for the info. ,
but I have a question : wouldn't that mean I have to prepare the thing
everytime I use it....
> Hi.
>
> If you are using Oracle 8i then you can use native dynamic SQL
> otherwise you must use Oracle package DBMS_SQL.
>
> HTH. Michael
>
> In article <885937$2br$1_at_nnrp1.deja.com>,
> skudsi_at_my-deja.com wrote:
> > Hi ,
> > I need help on how to call a procedure from within another procedure
> > based on a parameter. I have a procedure to which I pass the name of
> > the proper procedure to execute. I don't want to use IF statments to
> > execute the right procedure but to use the vriable name immediately.
> >
> > To Summerize :
> >
> > I need to see how I can do this:
> > calling_proc( the_procedure)
> > Begin
> > EXECUTE the_procedure(....)
> > END
> >
> > thanks for any help.
> > Sam
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sun Feb 13 2000 - 21:11:15 CST