Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need routine to auto import myfile.csv

Steve42Jul 11 2014 — edited Jul 23 2014

I have a stored procedure that can import MYFILE.CSV into an oracle table.

MYFILE.CSV , comes from a 3rd party, can be put on our server anywhere from

10AM to 3PM.

I need a routine that would check for C:\temp\myfile.CSV, say every 3 minutes. IF file exists, then import file.

Then rename the file. If possible, after file has been imported, stop the routine from checking until tomorrow.

Myfile.CSV file can contain up to 366 records.

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

PL/SQL Release 11.2.0.3.0 - Production

"CORE 11.2.0.3.0 Production"

TNS for Linux: Version 11.2.0.3.0 - Production

NLSRTL Version 11.2.0.3.0 - Production

What is the best way to do this?

TIA

Steve42

This post has been answered by Mike Kutz on Jul 11 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 20 2014

Added on Jul 11 2014

#database-key-features, #scheduler

5 comments

2,932 views