Show description

If there is no account for this ID, Oracle raises the predefined NO_DATA_FOUND exception, causing the program to stop. 19-22 If the balance is too low, I explicitly raise my own exception because I have encountered a serious problem with this account. 24 The EXCEPTION keyword denotes the end of the executable section and the beginning of the exception section in which errors are handled. 25-28 This is the error-handling section for the situation in which the account is not found. If NO_DATA_FOUND was the exception raised, it is trapped here, and the error is logged with the log_error procedure .

DBMS_CRYPTO Offers the ability to encrypt and decrypt common Oracle datatypes, including RAWs, BLOBs, and CLOBs. It also provides globalization support for encrypting data across different character sets. DBMS_MONITOR Provides an API to control additional tracing and statistics gathering of sessions. DBMS_WARNING Provides an API into the PL/SQL compiler warnings module, allowing you to read and change settings that control which warnings are suppressed, displayed, or treated as errors. 5. Resources for PL/SQL Developers With the release of the fourth edition, we are celebrating the tenth anniversary of Oracle PL/SQL Programming!

Take a Creative, Even Radical Approach We all tend to fall into ruts, in almost every aspect of our lives. People are creatures of habit: you learn to 44 Part I: Programming in PL/SQL Part I: Programming in PL/SQL 45 write code in one way; you assume certain limitations about a product; you turn aside possible solutions without serious examination because you just know it can't be done. Developers become downright prejudiced about their own programs, and often not in positive ways. " • "If I were using X or Y or Z product, it would be a breeze.