Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> PL/SQL Exception ideas?
I'm importing files containing a lot of bad data with the UTL_FILE
package.
This includes dates in the format , / / , i.e., no real date.
Naturally, if
I do a to_date on this, I get an exception, but I don't want to bail out
of the program
and roll to the bottom, I just want to skip it. I thought of two ways,
neither one
I like very much. 1) Build a separate function that tries to convert to
a date and
returns a boolean value indicating wether it was valid or 2) put a goto
in the exception
handler to continue rolling through the data. Does anyone have any
cleaner ideas?
![]() |
![]() |