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

Using inner join, Using INNER JOIN INNER JOIN is used to retrieve the ... Using INNER JOIN INNER JOIN is used to retrieve the data from all tables listed based on a condition of equality listed after keyword ON. If the condition is not meet, rows ar

Dynamic ranges- iterative control, Dynamic Ranges The PL/SQL lets you det... Dynamic Ranges The PL/SQL lets you determine the loop range dynamically at run time, as the example below shows: SELECT COUNT(empno) INTO emp_count FROM emp; FOR i IN 1..emp_cou

Pascal programming and mysql programming, I have a Pascal Source file that ... I have a Pascal Source file that needs to be compiled into a Service. In addition, there are various functions (Pascal Procedures I guess) that need to be created to Read and Write

Cursor variables as parameters, Cursor Variables As Parameters You can... Cursor Variables As Parameters You can declare the cursor variables as the formal parameters of the functions and procedures. In the illustration below, you define the REF CUR

Collection methods in pl sql, Collection Methods:   The collection me... Collection Methods:   The collection method is a built-in function or procedure which operates on the collections and is called using the dot notation. The methods like the C

Er diagrams, what are ER diagrams what are ER diagrams

Mechanistis theory-haeckel - origin of life, MECHANISTI S THEORY-HAECKEL (... MECHANISTI S THEORY-HAECKEL (1866) - Haeckel stating that after each catalysm, some new organism suddenly forms as a chance event in one stride from inanimate matter and sub

Using commit, Using COMMIT The COMMIT statements end the present trans... Using COMMIT The COMMIT statements end the present transaction and make permanent any changes made during that transaction. Till you commit the changes, other users cannot acc

Forall statement - syntax, FORALL Statement The FORALL statements instr... FORALL Statement The FORALL statements instruct the PL/SQL engine to bulk-bind the input collections before sending them to the SQL engine. Though the FORALL statement consists

Conditionals - sql, Conditionals - SQL At first sight SQL does not app... Conditionals - SQL At first sight SQL does not appear to have a single operator for expressing logical implication. In this respect it would be in common with most programming