Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How can I call a SQL Plus script from a PL/SQL script?

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

From: mbiker <annon_at_someaddress.com>
Date: Tue, 16 Jul 2002 12:03:40 GMT
Message-ID: <pb28ju4tn6dkc5eoi85oniblph7ube28a4@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 16 2002 - 07:03:40 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US