Icon View Incident Report

Minor Minor
Reported By: Uli Becker
Reported On: 2/9/2009
For: Version 2.02 Build 7
# 2919 Exceptions Being Displayed in EDB Manager Script Debugger with Pause On Exceptions Un-Checked

I wrote a script that creates some temporary tables. Since I don't know if the tables exist or not, I embedded the code in a begin - exception - end block.

During runtime that works fine, but in EDBManager an exception is raised every time if the table already exists, even with "Stop on Exceptions" set to false.

SCRIPT
BEGIN
   BEGIN
      EXECUTE IMMEDIATE 'DROP TABLE MyTable';
   EXCEPTION
   END;
END



Comments Comments
The ElevateDB Manager now handles the exceptions properly:

1) If Pause On Exceptions is checked, then exceptions are always stopped on and displayed.
2) If Pause On Exceptions is not checked, then only any exception that was left untrapped (no outer BEGIN..EXCEPTION block) will be displayed after the script is done executing.


Resolution Resolution
Fixed Problem on 2/12/2009 in version 2.02 build 8


Products Affected Products Affected
ElevateDB Additional Software and Utilities

Image