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
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 Go to previous message
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?
Previous Topic: How to copy records from one table to another?
Next Topic: replace function question
Goto Forum:
  


Current Time: Wed Feb 12 07:45:57 CST 2025