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>
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 nameReceived on Sat Oct 08 2005 - 01:45:01 CEST