Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: PL/SQL
In article <3919A575.20F31CC2_at_mindspring.com>,
James Efurd <jefurd_at_mindspring.com> wrote:
> I am new to Oracle and am trying to work in PL/SQL on v8.1.5.
>
> Is there any way (in PL/SQL) to access the command line for Unix or
NT?
> I am looking for any information on how to do this, either through
> staight PL/SQL or even through an external language if need be.
>
> I would appreciate any help.
>
> James
>
Through ver 8.0 pl/sql does not support direct access to OS commands
and I believe this is still true with 8.1. It is possible starting
with ver 8 to call external procedures, which are user provided
programs, from pl/sql. You will have to see the DBA Admin manual for
more information as I have yet to use them but I know they exist. For
version 7 some people used the dbms_pipe package to send requests to a
daemon style program that could issue commands via the C system call or
logic coded into the program.
-- Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice -- Sent via Deja.com http://www.deja.com/ Before you buy.Received on Wed May 10 2000 - 00:00:00 CDT
![]() |
![]() |