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: 25577
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: Driving Table
Next Topic: I am facing a problem during INSERT operation its giving Unique Constraint Error.
Goto Forum:

Current Time: Mon Aug 21 10:59:08 CDT 2017

Total time taken to generate the page: 0.04506 seconds