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: Help With procedures....

Re: Help With procedures....

From: <karsten_schmidt8891_at_my-deja.com>
Date: Mon, 14 Feb 2000 14:36:31 GMT
Message-ID: <8893tf$irv$1@nnrp1.deja.com>


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

Original text of this message

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