Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL

Re: PL/SQL

From: Mark D Powell <markp7832_at_my-deja.com>
Date: 2000/05/10
Message-ID: <8fcg1v$s4t$1@nnrp1.deja.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US