dbms_sql, isn't it?
Bernhard Riehm <briehm_at_perbit.de> wrote in message
news:7obngq$cbs$1_at_black.news.nacamar.net...
>
> You need to use Dynamic SQL
> You must use the DB_MS-Package and do the following steps:
> - DB_MS.OPEN_CURSOR
> - DB_MS.PARSE
> - DB_MS.BINDVARIABLE, if you want to use varaible in the SQL-Statement
> - DB_MS.EXECUTE
> - DB_MS.CLOSE_CURSOR
>
> Good Luck
> Bernhard Riehm
> perbit Software GmbH
>
> Vincent BARAT <vincent.barat_at_alcatel.fr> wrote in message
> news:37A94F3D.DB888055_at_alcatel.fr...
> > Hi !
> >
> > In a PL/SQL program, I have an SQL statement contained in a string
> > variable
> > and I want to execute it and get the result in a cursor (or anything
> > else).
> >
> > I can't figure out how to do that... Can you help me please ?
> >
> > Thanks a lot !
> >
> > --
> > Vincent BARAT
> >
> > ======================================================================
> > Web site: http://www.multimania.com/vbt/
> > Email (work): Vincent.Barat_at_alcatel.fr
> > Email (home): vbarat_at_iway.fr
> >
> > "Contrary to popular belief, Unix is user friendly.
> > It just happens to be selective about who it makes friends with."
> > ======================================================================
>
>
Received on Thu Aug 05 1999 - 05:47:10 CDT
