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

From: Finn Ellebaek Nielsen <fen_at_changegroup.dk>
Date: Tue, 23 Jul 2002 10:33:20 +0200
Message-ID: <3d3d14d1$0$11816$edfadb0f@dspool01.news.tele.dk>

Hi there.

I have written such a tool that can call any external process and even wraps SQL*Loader for PL/SQL. It could easiliy be extended to cover SQL*Plus as well. The C code has been written for Windows but could easily be ported to other OSs. Please let me know if you're interested.

Cheers,

Finn

"mbiker" <annon_at_someaddress.com> wrote in message news:pb28ju4tn6dkc5eoi85oniblph7ube28a4_at_4ax.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
Received on Tue Jul 23 2002 - 03:33:20 CDT