Return
-
Title
Toad generates WHEN OTHERS THEN NULL code in Schema Browser, "Sched. Job" tab -
Description
In Schema Browser, "Sched. Job" tab, right click to "Create Scheduler Job". The generated SQL shows:
...
BEGIN
SYS.DBMS_SCHEDULER.SET_ATTRIBUTE
( name => 'SCHEMA.PACKAGE'
,attribute => 'STOP_ON_WINDOW_CLOSE'
,value => FALSE);
EXCEPTION
-- could fail if program is of type EXECUTABLE...
WHEN OTHERS THEN
NULL;
END;About, “WHEN OTHERS THEN NULL”, why does Toad hide the error? If it failed, user needs to know the error message.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.