Re: PL/SQL Exception ideas?

The 'check' needs to be wrapped in it's own begin
exception
end;

block.
If you do it this way, just output a message and you can continue without a goto.

Hth,

--
Sybrand Bakker, Oracle DBA
Doug Cowles <dcowles_at_nospambigfoot.com> wrote in message news:3835AF47.46F197BC_at_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?
>
> - Dc.
>
Received on Fri Nov 19 1999 - 16:35:30 CST