What is pragma exception and how, when, where us

Answer Posted / shaik

Pragma Exception is a pre-compiled exception which is
particularly used to raise the user defined exceptions along
with the ORACLE error code.

PRAGMA EXCEPTION_INIT(exception_name, -Oracle_error_number);

ANY FURTHER CLARIFICATION CALL TO ME :09972372227

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are schema-level triggers?

660


What is the difference between rollback and rollback to statements?

687


what is transaction? : Sql dba

613


can a stored procedure call itself or recursive stored procedure? : Sql dba

657


what are the t string functions available in tsql? : Transact sql

617






what are the features and advantages of object-oriented programming? : Sql dba

625


How bulk collect improves performance?

648


What is function and procedure?

639


What is a ddl command?

622


What is pl sql script?

653


can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

630


What are views in sql?

640


How do I view a table in sql?

624


Does a primary key have to be a number?

604


what is sql? : Sql dba

647