RE: UTL_FILE and ksh

From: Andrey Bronfin <andreyb_at_elrontelesoft.com>
Date: Sun, 02 Sep 2001 10:43:52 -0700
Message-ID: <F001.0038071A.20010902104520@fatcity.com>

Hi Thomas !
I'm very interested in knowing the way of executing an OS command from with a PL/SQL block too.
Would U please post it or mail it to me . Thanks a lot .
Andrey.

DBAndrey

• 03-9254520
• 053-464562
• mailto:andreyb_at_elrontelesoft.com

-----Original Message-----
Sent: Friday, August 31, 2001 11:06 AM
To: Multiple recipients of list ORACLE-L

I got hold of some code that allows you to execute and Unix OS command from within Oracle...sorry I haven't fully read this email but is this something you are looking for ?

"hit any user to continue"

---

Kevin Thomas
Technical Analyst
Deregulation Services
Calanais Ltd.
(2nd Floor East - Weirs Building)
Tel: 0141 568 2377
Fax: 0141 568 2366
http://www.calanais.com

-----Original Message-----
Sent: 30 August 2001 22:47
To: Multiple recipients of list ORACLE-L

I'd look at java or equivalent to actually run a OS command to do 'ls -l' and get this result back.

hth
connor

• "Post, Ethan" <epost_at_kcc.com> wrote: > I have a directory that another process will be
  > placing files in and I will
  > be processing them using the UTL_FILE package. I
  > wish there was a way to
  > list the contents of a directory from PLSQL but I
  > don't think that there is.
  > My solution at this point is cron out a ksh script
  > that will check the
  > directory and call the procedure to handle the file.
  > I need to check if the
  > file is still being written to. I am checking to
  > see if the file is
  > writable but even when the file was opened by
  > another session using VI it
  > came back as writable so that does not appear to
  > work. What are your
  > solutions to this problem. Some of my other
  > thoughts are to have the
  > processes writing the file to only make the file
  > readable to other processes
  > once it is complete?
  >
  > Thanks,
  > Ethan
  > http://www.geocities.com/epost1
  >
  >

  ---

  --
  > This e-mail is intended for the use of the
  > addressee(s) only and may contain privileged,
  > confidential, or proprietary information that is
  > exempt from disclosure under law. If you have
  > received this message in error, please inform us
  > promptly by reply e-mail, then delete the e-mail and
  > destroy any printed copy. Thank you.
  >
  >

  ---

  ==
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.com
  > --
  > Author: Post, Ethan
  > INET: epost_at_kcc.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX:
  > (858) 538-5051
  > San Diego, California -- Public Internet
  > access / Mailing Lists
  >

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Connor McDonald
http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk)

"Some days you're the pigeon, some days you're the statue"

---

Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Thomas, Kevin
  INET: Kevin.Thomas_at_calanais.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrey Bronfin
  INET: andreyb_at_elrontelesoft.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Sun Sep 02 2001 - 12:43:52 CDT