Issue with UTL_FILE [message #383226] |
Tue, 27 January 2009 18:37  |
Danush
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  |
 |
BlackSwan
Messages: 26766 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.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.
Why are you reinventing the wheel & not using SQL*Loader (sqlldr) to load the CSV file?
|
|
|