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

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

About API Gateway

Most popular programming languages to learn in 2022

KNIME Server Administration Guide

473 startup failure post-mortems

Trapping Oracle Server Exceptions. 2 home back first prev next

Steve Muench – Dive Into APEX

NET Application Architecture: Logging SQL Exceptions in the Data

ORACLE-BASE - Introduction to PL/SQL

Oracle PeopleSoft on Cisco Unified Computing System and EMC VNX

Dive Into APEX – Old dog, new tricks.

Ben Myers, Author at Advant Technology Limited

Pandora FMS Monitoring Blog

Architecture for Network Prevent for Web with a Load Balancer