Re: PL/SQL Exception ideas?

From: Andy Thompson <AndrewT_at_MedImpact.com>
Date: Fri, 19 Nov 1999 21:11:29 -0800
Message-ID: <38362e8f@news1.jps.net>

How about putting the to_date function inside an anonymous block, inside your main loop. i.e.

  LOOP

     ....
     BEGIN
         TO_DATE(somestring);
     EXCEPTION
        WHEN OTHERS THEN
           print a message or something;
     END;
     ....
     ....

  END LOOP; HTH
Andy

Doug Cowles wrote in message <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 - 23:11:29 CST