Re: How can I call a SQL Plus script from a PL/SQL script?
From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Thu, 18 Jul 2002 09:24:46 +0600
Message-ID: <ah5cdn$q75gs$1_at_ID-127142.news.dfncis.de>
Date: Thu, 18 Jul 2002 09:24:46 +0600
Message-ID: <ah5cdn$q75gs$1_at_ID-127142.news.dfncis.de>
Just some thougths...
- use UTL_FILE package to read lines from your scripts.
- execute them by means of dynamic sql. It's easy especially if you are on 8i or later.
- add "some more complicated logic"
Regards,
-- Roman Mirzaitov Brainbench MVP for Oracle Administration www.brainbench.com "mbiker" <annon_at_someaddress.com> wrote in message news:pb28ju4tn6dkc5eoi85oniblph7ube28a4_at_4ax.com...Received on Thu Jul 18 2002 - 05:24:46 CEST
> 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