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