Regresar
-
Título
Toad generates WHEN OTHERS THEN NULL code in Schema Browser, "Sched. Job" tab -
Descripción
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.
Debe iniciar sesión
Tiene que estar conectado y contar con un contrato de mantenimiento vigente para ver los artículos de conocimiento premium.