Re: Call SQL from PL/SQL?

DA Morgan wrote:
> What version of Oracle?

9i, I believe.

> If 10g you could use DBMS_SCHEDULER.

OK, not that.

> 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.

[Quoted] That sounds like my code would have to know too much about the scripts. I want to be able to do the equivalent of

_at__at_scriptfile parameter

where someone can make arbitrary changes to scriptfile, like call other scripts, etc, and the calling program doesn't have to know about them.

--
  Helge Moulding
  hmoulding at gmail dot com                 Just another guy
  http://hmoulding.cjb.net/                  with a weird name