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

Keyword & Parameter Description:


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.


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


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
Transactions in SQL BEGIN TRANSACTION, COMMIT, and ROLLBACK, SQL has the same syntax except for START in place of BEGIN. However, START TRANSACTION is used only for outermost

Using NOT NULL Besides assigning an initial value, the declarations can impose the NOT NULL constraint, as the example below shows: acct_id INTEGER(4) NOT NULL := 9999; You ca

An analyst in the quality assurance office reviews the time lapse between receiving an order and shipping an order. Any orders that have not been shipped within a day of the order

Using FIRST and LAST FIRST and LAST return the first and last (minimum and maximum) index numbers in a collection. When the collection is empty, the FIRST and LAST return NULL

Parameter Modes   To define the behavior of formal parameters you use the parameter modes. The 3 parameter modes, IN, OUT, & IN OUT, can be used with any subprogram. Though, a

Closest Approximation to Relational Union - SQL Actually, just as SQL has several varieties of JOIN, it also has several varieties of UNION, none of which is equivalent to th

Fetching Across Commits The FOR UPDATE clauses acquire exclusive all row locks. All rows are locked when you open the cursor, and when you commit your transaction they are unl

Tautology - Equivalences Rules: If there Tautologies are not all the time as much easy to note as the one above so than we can use these truth tables to be definite that a sta

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean's wants to create a trigger that automatically updates the stock level of all pr

Using a Host Variable You can declare the cursor variable in the PL/SQL host environment like an OCI or Pro C program. To use the cursor variable, you should pass it as a host