Re: Call SQL from PL/SQL?

From: Helge Moulding <hmoulding_at_gmail.com>
Date: 7 Oct 2005 16:45:01 -0700
Message-ID: <1128728701.060996.213320_at_g43g2000cwa.googlegroups.com>


[Quoted] Sybrand Bakker wrote:
> I fail to see the problem.

[Quoted] I'm not really looking forward to writing a command parser. I guess you are telling me that (prior to 10g, maybe) Oracle has no way to simply do the equivalent of

_at__at_scriptfile parameter1

in PL/SQL. How about doing the equivalent of shelling out to run a shell script or command, e.g.

sqlplus name/pw_at_db @c:\folder\scriptfile parameter1

I don't like that much, because I'd like to not put the db password out in a text file, but is that at least possible?

--
  Helge Moulding
  hmoulding at gmail dot com                 Just another guy
  http://hmoulding.cjb.net/                  with a weird name
Received on Sat Oct 08 2005 - 01:45:01 CEST

Original text of this message