Hello,

I have a problem with SIGNAL and RESIGNAL statements. May I call these statements at another place in SQL stored procedure like in CONDITION HANDLER ? Still I was not successful. If yes can you send me any example?

Thanks for answer.

Yes,

THis is taken straight out of the V8.1 SQL Reference:

CREATE PROCEDURE SUBMIT_ORDER
(IN ONUM INTEGER, IN CNUM INTEGER,
IN PNUM INTEGER, IN QNUM INTEGER)
SPECIFIC SUBMIT_ORDER
MODIFIES SQL DATA
LANGUAGE SQL
BEGIN
DECLARE EXIT HANDLER FOR SQLSTATE VALUE '23503'
SIGNAL SQLSTATE '75002'
SET MESSAGE_TEXT = 'Customer number is not known';
INSERT INTO ORDERS (ORDERNO, CUSTNO, PARTNO, QUANTITY)
VALUES (ONUM, CNUM, PNUM, QNUM);
END

HTH

Andy

Thanks, but I would like to put SIGNAL statement into other place of procedures body, not only in HANDLER. This is my problem.

Yes, you should be able to use it outside a CONDITION statement. Could you post what you are trying to do (code) and tell me what you want it to do, maybe then I can help.

Andy

I don' t understand. Now everything works good, and 2 day ago I got error messages.

Thank you.