Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help With procedures....
Hi,
yes, you have to parse/execute it every time. (unless you do some
caching yourself. - but that's not worth it, in most cases)
Karsten
In article <887roi$ns3$1_at_nnrp1.deja.com>,
skudsi_at_my-deja.com wrote:
> 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.
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Feb 14 2000 - 08:36:31 CST