Stored procedures are the backbone of business logic encapsulation in GBase 8a. Effective exception handling and flow control not only prevent unexpected crashes but also make your code far more maintainable. This guide walks through diagnostics commands, exception handlers, loops, branches, and cursors in GBASE's China‑domestically developed MPP cluster database.

Diagnostics Commands

GBase 8a provides the GET DIAGNOSTICS statement to retrieve execution metadata without relying on implicit variables.

Number of Errors / Warnings

GET DIAGNOSTICS @ a = NUMBER ;

Enter fullscreen mode

Exit fullscreen mode

Stores the total count of warnings and errors for the current session into @a .

Rows Affected by the Last DML

GET DIAGNOSTICS @ a = ROW_COUNT ;

Enter fullscreen mode

Exit fullscreen mode

Reflects only the last INSERT, UPDATE, or DELETE operation.

Detailed Error Information

Capture the error number, SQLSTATE, and message text of the most recent error with CONDITION 1 :

GET DIAGNOSTICS CONDITION 1 @…