How do I code an exception to terminate a transaction?
How do I code an exception so that it doesn't terminate the program?

Hello,

If you want to stop a transaction via exception handling or with other techniques, use something like this

.
.
.
WHILE cuCursor%FOUND LOOP
EXIT WHEN cuCursor.field = 'exit'
END WHILE;

or

WHILE cuCursor%FOUND LOOP
IF cuCursor.field = 'exit'
GOTO EndLabel
END IF;
END WHILE;

<<EndLabel>>
.
.
.

or

WHILE cuCursor%FOUND LOOP
IF cuCursor.field = 'exit'
THROW endException
END IF;
END WHILE;

If your want to catch a exception use something like this

WHILE cuCursor%FOUND LOOP
BEGIN
nNumber = 'abc';
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
END WHILE;


Hope that helps ?

Manfred Peter
(Alligator Company GmbH)
http://www.alligatorsql.com

Thank you, it helped