Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Call SQL from PL/SQL?
"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
![]() |
![]() |