What is Pragma EXECPTION_INIT ? Explain the usage ?

Answer Posted / tulsi

The PRAGMA EXECPTION_INIT tells the complier to associate
an exception with an oracle error. To get an error message
of a specific oracle error.

e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error
number)

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many developers work on postgresql?

559


How do I edit a trigger in sql developer?

537


Is join an inner join?

531


How does one load ebcdic data? : aql loader

643


How to use boolean type in select statement?

580






What do you mean by query optimization?

544


does sql support programming? : Sql dba

605


Is pl sql still used?

507


Can I call a procedure inside a function?

549


What is sp_helptext?

588


What is the difference between local variables and global variables?

605


What is bind reference and how can it be created?

576


What is consistency?

708


Can two tables have same primary key?

531


What is sqlservr exe?

478