Re: How to execute a sql script in PL/SQL procedure ?

From: Rauf Sarwar <rsarwar_at_ifsna.com>
Date: 22 Jun 2002 11:39:16 -0700
Message-ID: <c2d690f2.0206221039.aa90534@posting.google.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<uh8gsn7m7ia4bf_at_corp.supernews.com>...
> "Epicentre team A" <oracle_at_epicentre.fr> wrote in message
> news:af1d08$c1g$1_at_wanadoo.fr...
> > Hi
> > How to execute a sql script in PL/SQL procedure ?.
> >
> > Thanks
> >
> >
>
> Not do it.
> Convert it to pl/sql
>
> Regards

I agree with Sybrand. First choice is to find a different route...BUT if you must, then one way would be to use UTL_FILE package to read commands from a script and execute them in dynamic PLSQL.

Regards
//RS Received on Sat Jun 22 2002 - 13:39:16 CDT