Re: Perform operating system's commands in PL/SQL?
Date: 1998/03/07
Message-ID: <6ds1dl$22pm$1_at_node17.frontiernet.net>#1/1
There is another option within PL/SQL:
there are a whole series of packages/functions/stored procedures that are
shipped with Oracle now.
Look in your /oracle/dbs/admin directory..or look on the database for the
Source. They are named with "DBMS_". For example, in O 7.3, there is now a
UTL_FILE package that allows you to read operating system files directly
from PL/SQL.
Regards,
Craig Brady
cpbrady_at_frontiernet.net
Chi Hoang wrote in message <34FA7B5C.89EE26D2_at_yahoo.com>...
>Here are the steps that will make this work:
>1. Write a daemon process that reads a certain oracle pipe that runs on
>the OS; I've only tried it on UNIX using Pro*C.
>2. You need write PL/SQL that sends and receives messages through that
>pipe. The outgoing message would be the UNIX command while the incoming
>message is the result of that command. I would place this in a package of
>some sort.
>
>
>
Received on Sat Mar 07 1998 - 00:00:00 CET