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 -> Re: Call SQL from PL/SQL?

Re: Call SQL from PL/SQL?

From: IANAL_VISTA <IANAL_Vista_at_hotmail.com>
Date: Sat, 08 Oct 2005 01:51:46 GMT
Message-ID: <Xns96E8BFE68708FSunnySD@68.6.19.6>


"Helge Moulding" <hmoulding_at_gmail.com> wrote in news:1128712293.126103.263170_at_g47g2000cwa.googlegroups.com:

> The application I'm working with includes a series of scripts that
> have to be called from the shell, or from SQL*Plus. I'd rewrite
> them as procedures, except that the company that provides the
> application may provide updates to the scripts, in which case I'll
> have to rewrite all those scripts again. I'd like to avoid that.
> (I know, I'd like it even better if the company that provides the
> application didn't saddle me with this mess of scripts, but that's
> a different issue.)
>
> Is there any way I can call these scripts from a procedure?
> --

Yes, by using either EXTERNAL PROCEDURES or have PL/SQL call JAVA which invokes the scripts. Received on Fri Oct 07 2005 - 20:51:46 CDT

Original text of this message

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