Product Documentation

FairCom Java & .NET Stored Procedures

Previous Topic

Next Topic

DhSQLException.getSqlState

Returns the SQL state as an integer error code.

Format

public Integer getSqlState()

Returns

An integer containing the SQL state (error code) of the exception.

Parameters

Throws

Example


CCREATE PROCEDURE test_proc()

BEGIN

Integer errstate;

String errmesg;

try

{

SQLIStatement insert_cust = new SQLIStatement ( "INSERT

INTO customer VALUES (1,2) ");

insert_cust.execute();

}

catch (DhSQLException e)

{

errstate = e.getSqlState();

errmesg = e.getMessageText() ;

}

END

TOCIndex