Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> PL/SQL Exception ideas?

PL/SQL Exception ideas?

From: Doug Cowles <dcowles_at_nospambigfoot.com>
Date: Fri, 19 Nov 1999 15:12:55 -0500
Message-ID: <3835AF47.46F197BC@nospambigfoot.com>


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?

Received on Fri Nov 19 1999 - 14:12:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US