ORA_PROF.Bad_Timer
Description
Raised when an invalid timer name is supplied to another ORA_PROF package procedure or function.
Syntax
Ora_Prof.Bad_Timer EXCEPTION;
Example
/*
** Create a timer, start it, run a subprogram,
** stop the timer, then display the time in
** seconds. Destroy the timer when finished.
*/
PROCEDURE timed_proc (test VARCHAR2) IS
i PLS_INTEGER;
BEGIN
Ora_Prof.Create_Timer('loop2');
Ora_Prof.Start_Timer('loop2');
test;
Ora_Prof.Stop_Timer('loop2');
Text_IO.Putf('Loop executed in %s seconds./n',
Ora_Prof.Elapsed_Time('loop2'));
Ora_Prof.Destroy_Timer('loop2');
EXCEPTION
WHEN ORA_PROF.BAD_TIMER THEN
text_io.put_line('Invalid timer name');
END;