Home » SQL & PL/SQL » SQL & PL/SQL » Issue with UTL_FILE (.csv)
Issue with UTL_FILE [message #383226] Tue, 27 January 2009 18:37 Go to next message
Messages: 8
Registered: December 2008
Junior Member
I am working on a package to read records from .csv file and validate each record and inset into tables.

All the code in the package works fine expect that the UTL_FILE utility stops regarding from the file and raises NO_DATA_FOUND exception. Since I have some code placed under NO_DATA_FOUND exception, that's executed. Why is this issue with UTL_FILE, even though there are entries in the flat file.

Please provide your thoughts.

Thank You.
Re: Issue with UTL_FILE [message #383227 is a reply to message #383226] Tue, 27 January 2009 18:46 Go to previous message
Messages: 24963
Registered: January 2009
Location: SoCal
Senior Member
>Please provide your thoughts.
The code has a bug in it.

Why do you expect us to debug your code that we can not see because you decided we did not need to see it?

You need to help us by following the Posting Guidelines as stated below.
So we can help you.

Why are you reinventing the wheel & not using SQL*Loader (sqlldr) to load the CSV file?
Previous Topic: How to copy records from one table to another?
Next Topic: replace function question
Goto Forum:

Current Time: Tue Oct 25 12:52:45 CDT 2016

Total time taken to generate the page: 0.08036 seconds