White Papers

On Ignoring, Locking, and Parsing

Overview There's a programming construct, WHEN OTHERS, in PL/SQL that the author wishes weren't there. This clause, when used in an exception block, catches any unhandled exceptions. There are times when this is useful, such as for logging errors. But the problem the author sees is that far too many people use the WHEN OTHERS clause without following it by a RAISE or RAISE_APPLICATION_ERROR call. That effectively hides the error. In reality, the error happened, but it was not handled in any meaningful way; it was just ignored - silently. The invoker of one's code has no idea that something went horribly wrong and that the code failed, and he or she typically thinks that everything was, in fact, successful.

Download White Paper

By downloading you agree to our Terms and Conditions. These include information regarding use of your personal data.

Publisher
Oracle
File Format
HTML
Date Published
Mar 29, 2008
Format
White Papers
Topics
Programming Languages, Database Management

Similiar White Papers

Building a Hybrid Data Warehouse Model

Building a Hybrid Data Warehouse Model

This paper discusses the hybrid design and provides a fully functional reference implementation. The system runs on Orac

Publisher: Oracle  |  Tags: data, database, warehouse

MSDN Webcast: Using LINQ With Relational Data (Level 100)

MSDN Webcast: Using LINQ With Relational Data (Level 100)

One of the most common forms of data used in applications today continues to be relational data that is stored in variou

Publisher: Microsoft  |  Tags: applications, data, database

MySQL Stored Procedure Programming: Error Handling

MySQL Stored Procedure Programming: Error Handling

The perfect programmer, living in a perfect world, would always write programs that anticipate every possible circumstan

Publisher: O'Reilly Media  |  Tags: applications, business applications, server, shuttle, software

MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 With Andrew Karcher (Level 200)

MSDN Webcast: geekSpeak: T-SQL Tips and Tricks in SQL Server 2008 With Andrew Karcher (Level 200)

This webcast is for Transact-SQL (T-SQL) lover. The presenter introduces to several new features of SQL Server 2008, inc

Publisher: Microsoft  |  Tags: data

Efficient Use of PL/SOL String Functions for Unicode Applications

Efficient Use of PL/SOL String Functions for Unicode Applications

This white paper focuses on performing implications of PL/SQL applications for Unicode database server using a UTF-8 dat

Publisher: Oracle Corporation  |  Tags: applications, database, server

Oracle White Papers

A Taxonomy of the Linux Network Stack

A Taxonomy of the Linux Network Stack

This paper tries to give readers not familiar with the Linux network stack a gentle introduction to the fundamental conc

Publisher: Oracle  |  Tags: data, ip, kernel, linux, network

GUIDEBOOK: ORACLE'S SIEBEL CRM ON DEMAND

GUIDEBOOK: ORACLE'S SIEBEL CRM ON DEMAND

Oracle's Siebel CRM On Demand has leveraged its history and experience in CRM to provide customers with deeper functiona

Publisher: Oracle  |  Tags: crm

Oracle Forms 10g - Forms Look and Feel

Oracle Forms 10g - Forms Look and Feel

Oracle Forms application have traditionally behaved as, and looked like, desktop applications. Even when Oracle Forms ap

Publisher: Oracle  |  Tags: applications, css

Oracle Blends Managed Services With OnDemand Pricing

Oracle Blends Managed Services With OnDemand Pricing

Growing businesses are increasingly realising that Managed Services offer a scalable, flexible route forward. This white

Publisher: Oracle

Ten Things to Know About Grid Computing on Windows

Ten Things to Know About Grid Computing on Windows

This Oracle whitepaper offers insights into Oracle Grid.A grid allows a business to add capacity, cheaply, whenever it i

Publisher: Oracle  |  Tags: application server, computing, database, server