var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: retrieving line of last error
Is it possible to get the line-number where the last error ocurred ?
CREATE OR REPLACE PROCEDURE do_stupid
FOR i IN 1..5
temp := sysdate;
tempNum := 2;
tempNum := tempNum / 0;
tempNum := 3;
WHEN OTHERS THEN
-- i want to access the line-number of the error "tempnum / 0"
Thank You !
you can access the errors of a compilation by using the following
SELECT OWNER, NAME, TYPE, SEQUENCE, LINE, POSITION, TEXT
FROM SYS.ALL_ERRORS WHERE owner = 'SYS' AND name = 'NONAME';
or use the AlligatorSQL ;-)
Hope this helps ?
I want to catch runtime Errors. A "Division by zero" doesnt throw a compilation error. The "Division by zero" should only be an example for everything which could throw an error - there could also be a "index not found" or anything else.