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
EXIT-WHEN The EXIT-WHEN statement permits a loop to complete conditionally. Whenever the EXIT statement is encountered, the condition in the WHEN clause is computed. When the co

Tautologies: Above given table allows us to read the truth of the connectives in the next manner. Just expect we are looking at row three. It means this says that, if there P

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in __________________.

Raise_application_error -  procedure of package DBMS_STANDARD , allows to issue an user_defined error messages by stored sub-program or database trigger.

Parameter and Keyword Description: procedure_name The user-defined procedure is declared by this construct. parameter_name: This identifies the formal parameter t

%NOTFOUND The %NOTFOUND is logical, opposite of the %FOUND. The %NOTFOUND yields FALSE if the last fetch returned a row, or TRUE when the final fetch failed to return a row. I

Delimiters A delimiter is a simple or compound symbol which has a special meaning to PL/SQL. For example, you use delimiters to symbolize an arithmetic operation like additio

Advantages of Wrapping   The PL/SQL Wrapper convert the PL/SQL source code into a transitional form of the object code. By hiding the application internals, the Wrapper secure

a. Create a table odetails_new. It has all the attributes of odetails and an additional column called cost, whose values are the product of the quantity and price of the part bein

Defining and Declaring Records To create records, you have to define a RECORD type, and then declare records of that type. You may also define RECORD types in the declarative