Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between pragma exception_init and
raise_application_error
- 1 Answers
- 36549 Views
- Aetins, State Street, I also Faced
- E-Mail Answers
Answer Posted / welcomeashwin
PRAGMA EXCEPTION_INIT allows to associate an Oracle error
number with the name of a user-defined error. Here you need
to defined user-defined exception before it is used in
PRAGMA EXCEPTION_INIT. There are two parameters: exception
name and error code.
RAISE_APPLICATION_ERROR allows to create meaningful error
msg.it works with un-named user defined exceptions. It
associates the number of the error with the text of the
error. Therefore, the user-defined exception does nat have a
name associated with it. There are three parameter:
err_number, err_msg, keep-err
| Is This Answer Correct ? | 40 Yes | 4 No |
Post New Answer View All Answers
Does sql full backup truncate logs?
What is dense_rank in sql?
How do I count records in sql?
Which data type is a composite type?
What are the different types of dbms?
What are the main features of cursor?
Can you selectively load only those records that you need? : aql loader
Can a varchar be a primary key?
where are cookies actually stored on the hard disk? : Sql dba
What are local and global Indexes and where they are useful.
How long it takes to learn pl sql?
what is the difference between primary key and unique key? : Sql dba
What are aggregate functions in sql?
State some properties of relational databases?
Can we edit a view in sql?
