Re: Using Exception in a stored procedure when validating a date

Have you tried surrounding the area of code using the to_date function in its own block. You can then trap any exception caused by the to_date, using an insert/delete statement when it fails. Using this method would ensure you colud continue the cursor loop, fetching the next row, to do the to_date on. Rather than entering the procedures exception handling, and being kicked out of the loop.

This may help, unless I've misunderstood the query fully Received on Thu Apr 04 2002 - 21:12:14 CEST