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: Trigger or Procedure that Scans a folder for TXT files

Re: Trigger or Procedure that Scans a folder for TXT files

From: <tjmxyz_at_my-deja.com>
Date: 2000/05/26
Message-ID: <8gm0bq$645$1@nnrp1.deja.com>#1/1

I agree however, This is what the customer would like.

Reason is that they have a System in places which interfaces to other systems which also must interface to ours. They do not want to change it to accomodate my software.

The purpose is to integrate certain peaces of information from another Oracle system into my system.

I would like to handle it all with transaction based triggers and

However, I cannot get them to do this.
Instead i must read the text files into my INQUEUE database. Where I have code that handles the integration in Triggers.

It is not a user based process rather two servers talking to each other but not replication as it is only a small peace of information which must be converted into my format ect.

Ideally I would have them insert directly into my INQUEUE but that's not an option as far as they are concerned.

So is it possible to read the contents of a text file at a given interval or should I write a server program to handle this. I would like to do it on the POracle Server as possible as I stated.

However, I agree completely with all your arguements.

Cheers!

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri May 26 2000 - 00:00:00 CDT

Original text of this message

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