Use the sql_get_message_vector routine to retrieve information
from the RDB$MESSAGE_VECTOR array. The array provides information
about the execution status of SQL statements. Index 2 of the sql_
get_message_vector routine returns the primary status code of
the last SQL statement. This index is comparable to the SQLCODE
status parameter.
The ANSI/ISO SQL standard does not include the sql_get_message_
vector routine or the RDB$MESSAGE_VECTOR array. For application
programs that comply with the standard, use the SQLCODE or
SQLSTATE status parameters. Furthermore, the status values
returned for a particular condition may change in future versions
of Oracle Rdb.
The status values that are stored in the message vector are
intended to be supplementary information to the status parameters
SQLCODE and SQLSTATE. Use the sql_get_message_vector routine if
the information provided by SQLCODE or SQLSTATE is ambiguous and
your application needs a more specific error code to handle the
error condition.
Relationship Between sql_message_vector and RDB$MESSAGE_VECTOR
shows the relationship between the indexes returned by sql_
message_vector and the fields in RDB$MESSAGE_VECTOR.
Table 1-1 Relationship Between sql_message_vector and
RDB$MESSAGE_VECTOR
sql_message_vector
Indexes RDB$MESSAGE_VECTOR Fields
Index 1 RDB$LU_NUM_ARGUMENTS
Index 2 RDB$LU_STATUS
Index 3 RDB$LU_ARGUMENTS
Index 4-20 Return status for follow-on messages,
if any