____________ exception directs the complier to add the user defined error message to the oracle error number

Options
- Pragma EXCEPTION_INIT
- Pragma Exception
- ORA_EXCEPTION
- ORA_USER_EXCEPTION


CORRECT ANSWER : Pragma EXCEPTION_INIT

Discussion Board
oracle(sql and pl/sql)

Hi mam greetings to you..
thank you for given these quos and ans..
Mam i am looking for oracle developer as a experience candidate 3+ years of experience...pls provide interview quos and answers...for experience person


deva 08-23-2017 05:19 AM

oracle(sql/plsql)

Hi mam..greetings to you..
these are very useful to every one..
pls give further requremet quostions...

deva 08-23-2017 05:15 AM

Pragma EXCEPTION_INIT

The pragma EXCEPTION_INIT directs the compiler to add the user defined error message to the Oracle error number. The pragma EXCEPTION_INIT associates an exception name with an Oracle error number. You can intercept any ORA- error and write a specific handler for it instead of using the others handler. Pragma is a keyword directive to execute proceed at compile time. The pragma EXCEPTION_INIT function takes two arguments: 1. exception_name and 2. error_number

You can define pragrma EXCEPTION_INIT in DECLARE BLOCK on your program: PRAGMA EXCEPTION_INIT(exception_name, -error_number);

The exception_name and error_number define on yourself, where exception_name is a character string up to 2048 bytes supports and error_number is a negative integer range from -20000 to -20999.

A pragma is a compiler directive that is processed at compile time, not at run time.

Prajakta Pandit 02-10-2017 04:45 AM

ONLINE EXAM

THE EXAM QUESTIONS ARE VERY NICE AND VERY USEFUL ONES..BUT SERVER IS WEAK

GOPIKA KK 11-25-2015 01:45 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement