Returns the formatted message associated with the ith error on the error stack (the default is the top-most error).
FUNCTION Tool_Err.Message
(i PLS_INTEGER := TOPERROR)
RETURN VARCHAR2;
Parameter | Description |
---|---|
i | An integer that specifies an error on the error stack. |
An error message.
/*
** Determine the number of errors
** on the stack. Then, loop through stack,
** and print out each error message.
*/
PROCEDURE print_all_errors IS
number_of_errors PLS_INTEGER;
BEGIN
EXCEPTION
WHEN OTHERS THEN
number_of_errors := TOOL_ERR.NERRORS;
FOR i IN 1..number_of_errors LOOP
TEXT_IO.PUT_LINE(TOOL_ERR.MESSAGE(i-1));
END LOOP;
END;