Re: How can I call a SQL Plus script from a PL/SQL script?

"dharma-" <ajdharmaraj_at_hotmail.com> wrote in message news:fb451bc0.0207161223.5d79b2c9_at_posting.google.com...
> > I have some SQL Plus scripts that help me load data. I now need to
> > add some more complicated logic so PL/SQL is required. The PL/SQL
> > will need a loop which calls the existing SQL Plus scripts passing a
> > date.
> >
> > Is this possible?
> >
> > Rewriting the existing SQL Plus scripts to use PL/SQL would be a large
> > job. These scripts work and have been in production for a while. I
> > would like to avoid making major changes.
> >
> > Thanks,
> > Don
>
> Yes its possible, but if you are in a unix box you can write a simple
> c function which resides in the server to call the scripts and add a
> external procedure (extproc) TNS entry to call it from pl/sql. that
> should do the trick.
> HTH.
> dharma-

and it's damn inefficient and will setup a second connection and possibly expose passwords

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address