Re: Call SQL from PL/SQL?

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 07 Oct 2005 14:35:10 -0700
Message-ID: <1128720901.148811_at_yasure>


Helge Moulding wrote:
> 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?
> --
> Helge Moulding
> hmoulding at gmail dot com Just another guy
> http://hmoulding.cjb.net/ with a weird name
>

[Quoted] [Quoted] What version of Oracle? If 10g you could use DBMS_SCHEDULER. [Quoted] If a previous version you could write an external procedure or read them in using an external table or UTL_FILE and then put together some way to modify them on-the-fly into anonymous blocks.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Oct 07 2005 - 23:35:10 CEST

Original text of this message