Trapping Oracle Server Exceptions. 2 home back first prev next last What Will I Learn? Describe and provide an example of an error defined by the Oracle. - ppt download

Por um escritor misterioso

Descrição

3 home back first prev next last Why Learn It? PL/SQL error handling is very flexible and allows programmers to use both errors defined by the Oracle server and errors defined by the programmer. This lesson discusses predefined and nonpredefined Oracle Server errors. –Predefined errors are the common Oracle errors for which PL/SQL has predefined exception names. –Non-predefined errors make use of the ORA error codes and messages. –The syntax is different for each, but you can trap both kinds of errors in the EXCEPTION section of your PL/SQL program.
20 home back first prev next last Try It / Solve It The exercises in this lesson cover the following topics: –Listing and describing different types of PL/SQL exception handlers –Differentiating between errors that are handled implicitly and explicitly by the Oracle Server –Trapping predefined Oracle Server errors –Trapping non-predefined Oracle Server errors