how to disable EXCEPTIONS in PL/SQL ?

• Quoting Sy Jerry to All dated 10-10-94 ***
  > I am writing several PL/SQL procedures and I can't seem to find a
  > way to disable EXCEPTIONS.
  

You cannot disable exceptions, any more than you can disable begin or declare statements. Exceptions are raised, what you can do is trap them using normal PL/SQL syntax. A PL/SQL block consists of

DECLARE
BEGIN
EXCEPTION
END You are apparently neglecting to provide any exception handlers. The simple handler

exception when others then null;
end

Will cause the exception to be ignored. Received on Tue Oct 11 1994 - 21:19:39 CET