MQSeries.net :: View topic

madi · Posted: Mon Oct 23, 2006 8:08 am Post subject:

Hi All

I tried to find some sample code for using the handlers in eSQL

I need to call a stored procedure from an external database and if it throws an exception i need to execute a set of statements

The actual code is

CallStoredProc(variable);

CASE variable
WHEN ''
---
---
END CASE;

Now I want to put a handler to take care of any exceptions related to the database or storedproc

If i get an exception in the CallStoredProc(variable); i want to set the return code my self and then execute the CASE statement

Now for that

DECLARE EXIT/CONTINUE?? HANDLER FOR SQLSTATE LIKE'%'
BEGIN
Call StoredProc(variables);
SET v_returnCode = 16;
END;

or

DECLARE CONTINURE HANDLER FOR SQLSTATE LIKE '%'
BEGIN
SET v_returnCode = 16;
END;

and then all the actual code

i think it is the second piece of code

plz advise

--madi