Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How can I call a SQL Plus script from a PL/SQL script?
> 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-
Received on Tue Jul 16 2002 - 15:23:59 CDT