Re: Call SQL from PL/SQL?
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 07 Oct 2005 17:30:44 -0700
Message-ID: <1128731436.284899_at_yasure>
>
>
> 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
Date: Fri, 07 Oct 2005 17:30:44 -0700
Message-ID: <1128731436.284899_at_yasure>
Helge Moulding wrote:
> Sybrand Bakker wrote:
>
>>I fail to see the problem.
>
>
> 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
Use operating system authentication ... do not put the password into the file. Look up OPS$ accounts and external authentication at tahiti.oracle.com.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Sat Oct 08 2005 - 02:30:44 CEST