5. Embedded SQL for Ada : The SQL Communications Area : SQLSTATE Variable Usage
 
Share this page                  
SQLSTATE Variable Usage
You can use the SQLSTATE variable in an ESQL/ Ada program to return status information about the last SQL statement that was executed. SQLSTATE must be declared in a declaration section and must be in uppercase. Also, it is valid across all sessions, so you only need to declare one SQLSTATE per application.
To declare this variable, use:
SQLSTATE: String(1..5);
For more information about SQLSTATE, see the SQL Reference Guide.