tailieunhanh - Oracle Database 11g PL/SQL Programming P2

These enhancements are briefly reviewed in the following subsections. Chapter 3 covers the SIMPLE_INTEGER datatype. Chapter 4 covers the continue statement. Chapter 6 demonstrates the cross-session PL/SQL function result cache, and both mixed, named, and positional notation calls. Automatic subprogram inlining and the PL/SQL Native Compiler are covered in Chapter 9. Chapter 16 covers web application development and the multiprocess connection pool. | Chapter 1 Oracle PL SQL Overview 15 can also call the FORMAT_CALL_STACK or FORMAT_ERROR_STACK from the same package to work with thrown exceptions. The following is a simple example KT DECLARE local_exception EXCEPTION FUNCTION nested_local_function RETURN BOOLEAN IS retval BOOLEAN FALSE BEGIN RAISE local_exception RETURN retval END BEGIN IF nested_local_function THEN No raised exception END IF EXCEPTION WHEN others THEN --------------------------- ------------------------------- ---------------------------- END This script produces the following output KT ----- PL SQL Call Stack object line object handle number name 20909240 18 anonymous block ORA-06512 at line 7 ORA-06512 at line 11 ORA-06510 PL SQL unhandled user-defined exception You will likely find the FORMAT_ERROR_BACKTRACE the most helpful. It captures the line where the first error occurs at the top and then moves backward through calls until it arrives at 16 Oracle Database 11g PL SQL Programming the initial call. Line numbers and program names are displayed together when named blocks are involved in an event stack. Chapter 5 contains more on error management. Wrapping PL SQL Stored Programs Beginning with Oracle 10g Release 2 the database now supports the ability to wrap or obfuscate your PL SQL stored programs. This is done by using the DBMS_DDL package CREATE_WRAPPED procedure. You use it as follows T BEGIN CREATE OR REPLACE FUNCTION hello_world RETURN STRING AS BEGIN RETURN Hello World