| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Reraising exceptions
Will the insert take place in this piece of code
DECLARE
err_num NUMBER;
err_msg VARCHAR2(100);
BEGIN
...
EXCEPTION
...
WHEN OTHERS THEN
err_num := SQLCODE;
err_msg := SUBSTR(SQLERRM, 1, 100);
INSERT INTO errors VALUES (err_num, err_msg);
RAISE; /* or RAISE_APPLICATION_ERROR */
END;
Received on Fri Apr 02 1999 - 09:38:37 CST
![]() |
![]() |