MQSeries.net :: View topic - Urgent :trapping exception raised by stored procedure SYBASE

unilog

I'm trying to trap an error raised by a stored procedure SYBASE with the instruction "raise_error".

The stored procedure is called with the "PASSTHRU" instruction via ODBC under AIX 4.3.3.

In the current situation, if an error is raised in the Stored Procedure, no operations are validated in the database SYBASE, no error is returned to WMQI and the flow continues as if there was no error, whereas I expected an exception in WMQI.

If I do the same operation with ORACLE, it works correctly.

What should I do to make it work with SYBASE ?

Configuration :
* ORACLE 8.1.7
* SYBASE 12.5
* WMQI 2.1 + CSD2
* MQSERIES 5.2