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
Using the BULK COLLECT Clause The keywords BULK COLLECT specify the SQL engine to bulk-bind output collections before returning them to the PL/SQL engine. You can use these ke

Assignment Statement: The assignment statement sets the present value of the variable, parameter, field, or element. The statement consists of an assignment target followed by

GOTO Statement The GOTO statement branches to a label unconditionally. The label must be exclusive within its scope and should precede an executable statement or a PL/SQL block.

ROWID The ROWID returns the rowid (binary address) of a row in the database table. You can use the variables of the type UROWID to store rowids in a readable format. In the il

Defining and Declaring Collections To create the collections, you must define a collection type, and then declare the collections of that type. You can define the VARRAY types a

Assignment of Variable - Updating a Variable Syntax: SET SN = SID ('S2'); This can obviously be read as "set the variable SN to be equal in value to SID ( 'S2' )".

Restriction and AND - SQL Restriction is available via the WHERE operator, and so it is in SQL. However, by Example showing how a certain simple restriction can be expressed u

%ROWTYPE: This attribute gives a record type which represents a row in the database table or a row fetched from a formerly declared cursor. The Fields in the record and corresp

SSRS Report Writing Project Description: This report is part of a larger project to make a SQL Server Reporting Service (SSRS) based reporting solution. There can be more rep

BEGIN Parameter Description in pl sql: BEGIN: This keyword signals the beginning of the executable section of a PL/SQL block, that contains executable statements. The execut