• 0

Oracle 9i vs external file


Question

I am writing a supoort database for a local company and am doing it in oracle 9i. Its for my degree

The company run a PBX local exchange phone system, which keeps a txt file of what number has rung in and which dept they are ringing (support sales). I need help on how to get the new information from the txt file as soon as it is saved in it to the oracle database to bring up the customer's details.

Any ideas of what i have to do and how to do it

Link to comment
Share on other sites

2 answers to this question

Recommended Posts

  • 0

Easiest way I suppose is to have a process that watches the file for new changes and does an SQL insert when a new record is found. Although the better way would be to have it directly insert to the SQL database instead of dealing with the file, but doesn't sound like that would happen.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.