View Issue Details

IDProjectCategoryView StatusLast Update
0001700Database Workbench v6Firebird Modulepublic2022-01-26 10:46
ReporterJacek Laskowski Assigned ToMartijn Tonies  
PrioritynormalSeveritymajorReproducibilityhave not tried
Status acknowledgedResolutionopen 
Product Version5.6.2 
Summary0001700: Problem with debugging Firebird 3 stored procedure with fetching exception SQLSTATE into variable
DescriptionI try debug SP with

WHEN ANY DO...

statement inside which I want to capture error codes:


    DDL = 'some wrong DDL code';
    EXECUTE STATEMENT DDL;
    WHEN ANY DO
    BEGIN
      ERROR_GDSCODE = GDSCODE;
      ERROR_SQLCODE = SQLCODE;
      ERROR_SQLSTATE = SQLSTATE; <--- on this line exception occurs
    END
Additional Informationsee screenshot for details
TagsNo tags attached.

Activities

Jacek Laskowski

2019-09-04 15:53

reporter  

vps_2019.09.04_03.png (71,464 bytes)   
vps_2019.09.04_03.png (71,464 bytes)   

Jacek Laskowski

2019-09-05 13:09

reporter   ~0000500

in the latest version 5.6.6 (I bought an update yesterday) the exception is gone, but the SQLSTATE value is not get/read

Jacek Laskowski

2019-09-05 13:29

reporter   ~0000501

Next problem. When I use in SP this statement:

WHEN GDSCODE no_dup DO

then SP is compiled but debugging is not possible, because DBW raise error: "Preprocessor errors found - cannot debug procedure"


the problem is 'GDSCODE no_dup', although this is the allowed FB syntax:

https://firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25-psql-handleexceptions.html

Issue History

Date Modified Username Field Change
2019-09-04 15:53 Jacek Laskowski New Issue
2019-09-04 15:53 Jacek Laskowski File Added: vps_2019.09.04_03.png
2019-09-05 13:09 Jacek Laskowski Note Added: 0000500
2019-09-05 13:29 Jacek Laskowski Note Added: 0000501
2019-09-10 13:50 Martijn Tonies Assigned To => Martijn Tonies
2019-09-10 13:50 Martijn Tonies Status new => assigned
2019-09-16 11:03 Martijn Tonies Summary Problem with debugging Firebird 3 stored procedure with catching exception => Problem with debugging Firebird 3 stored procedure with fetching exception SQLSTATE into variable
2022-01-12 13:35 Martijn Tonies Project Database Workbench v5 => Database Workbench v6
2022-01-26 10:46 Martijn Tonies Status assigned => acknowledged