EXCEPTION_INIT Pragma

The pragma EXCEPTION_INIT relates an exception name with an Oracle error number. Which allow you to refer to any internal exception by the name and to write a specific handler for it rather than of using the OTHER handler.

Syntax:

Posted Date: 10/8/2012 6:03:25 AM | Location : United States

Ask an Expert

Related Discussions:- Exception_init pragma - pl/sql, Assignment Help, Ask Question on Exception_init pragma - pl/sql, Get Answer, Expert's Help, Exception_init pragma - pl/sql Discussions

Write discussion on Exception_init pragma - pl/sql
Your posts are moderated

Write your message here..

Related Questions

Cursors - syntax, Cursors   To execute the multi-row query, the Oracle... Cursors   To execute the multi-row query, the Oracle opens an unnamed work region which stores the processing information. The cursor names the work region, access the informa

Package - pl/sql programming, What Is a Package? The package is a sch... What Is a Package? The package is a schema object that group logically related PL/SQL items, types, and subprograms. The Packages usually have 2 parts, a specification & a bo

Using savepoint, Using SAVEPOINT The SAVEPOINT names and marks the pre... Using SAVEPOINT The SAVEPOINT names and marks the present point in the processing of a transaction. Used with the ROLLBACK TO statement, the savepoints undo parts of a transac

Package body, The Package Body The package specification is implemented... The Package Body The package specification is implemented by the package body. That is, the package body has the definition of every cursor and the subprogram declared in the p

Procedural constraint enforcement (triggers) , Procedural Constraint Enforc... Procedural Constraint Enforcement (Triggers) SQL has an alternative method of addressing database integrity, involving event-driven procedural code. The special procedures th

Testing triggers, Demonstrate your knowledge of PL/SQL programming by writi... Demonstrate your knowledge of PL/SQL programming by writing and thoroughly testing triggers and stored procedures associated with an e-commerce application that provides security l

Number types in pl/sql, Number Types The Number types permit you to sto... Number Types The Number types permit you to store the numeric data (real numbers, integers, and floating-point numbers), show quantities, and do computations. BINARY_INTEG

How bulk bind helps improvement in performance?, How Bulk Binds Improve Per... How Bulk Binds Improve Performance The assigning of values to the PL/SQL variables in SQL statements is known as binding. The binding of the whole collection at once is know

%found - implicit cursor attributes, %FOUND Until the SQL data manipul... %FOUND Until the SQL data manipulation statement is executed, the %FOUND yields NULL. Afterward, the %FOUND yields TRUE, when an INSERT, UPDATE, or DELETE statement affected o

Magento change address format depending on store, Magento change address fo... Magento change address format depending on store Project Description: What I need is that depending on the store in which the customer bought the address should change the fo