Keyword & parameter description - exception_init pragma, PL-SQL Programming

Keyword & Parameter Description:

PRAGMA:

These keywords signify that the statement is a pragma (i.e. compiler directive). The Pragmas are processed at the compile time, not at the run time. They do not affect the meaning of the program; which simply convey the information to the compiler.

exception_name:

This identifies a user-defined exception formerly declared within the present scope.

error_number:

This is any of the valid Oracle error number. These are similar error numbers returned by the function SQLCODE.

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







Related Discussions:- Keyword & parameter description - exception_init pragma, Assignment Help, Ask Question on Keyword & parameter description - exception_init pragma, Get Answer, Expert's Help, Keyword & parameter description - exception_init pragma Discussions

Write discussion on Keyword & parameter description - exception_init pragma
Your posts are moderated
Related Questions
IN OUT Mode An IN OUT parameter passes initial values to the subprogram being called and return efficient values to the caller. Within the subprogram, an IN OUT parameter acts

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

%ROWCOUNT When its cursor or cursor variable is opened, the %ROWCOUNT is zeroed. Before the first fetch, the %ROWCOUNT yields 0. Afterward, it yields the number of rows fetche

Example of Check Constraints Example: Workaround for when subqueries not permitted in CHECK constraints CREATE FUNCTION NO_MORE_THAN_20000_ENROLMENTS ( ) RETURNS BOOLEAN

Need Windows and Linux system Administrator We are seeking a part time system administrator to take care of our servers. Your things to do would add, but not limited to: -

Use the PLS_INTEGER Datatype When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER

Nested Tables versus Index-by Tables The Index-by tables and nested tables are just similar. For e.g.  They have similar structure and their individual elements are accessed in

Data Types and Representations This explains the concept possible representation, abbreviated possrep, and explains how these can be used in conjunction with constraints to de

Effects of NULL for UNIQUE Specification When a UNIQUE specification u for base table t includes a column c that is not subject to a NOT NULL constraint, the appearance of sev

Using TRIM This process has two forms. The TRIM removes an element from the end of the collection. The TRIM(n) removes the n elements from the end of the collection. For e.g.