SQL_ERROR_MESSAGE¶

Applies to: ORAFlex SQLFlex MYSQLFlex PGFlex DB2Flex

This command is used to get an error message from a given SQL statement. If the given statement is executed with no errors, the variable specified with this command will be blank. Otherwise the message will be stored in the given variable. Note that unless specified, strings have a size limit of 80 characters, so using a variant can ensure the full message is retrieved.

Syntax

SQL_ERROR_MESSAGE {variable}

Parameter	Description
variable	Variable to hold the error message

Example

SQL_ERROR_MESSAGE sError

SQL_ERROR_MESSAGE2