Topic: SQL*Plus and PL/SQL >> Clarification regarding "Raise Application Error" and "seq_collision exception"
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Clarification regarding "Raise Application Error" and "seq_collision exception" |
| muzu |
Posted: Sep 06, 2007 11:51:56 AM |
Total Post: 37
Joined: Aug, 2007
|
What does the RAISE_APPLICATION_ERROR mean ? When this error is raised whether the database errors are occurred ? Please can any one explain clearly what this error means ?
Also What does the seq_collision exception means and when it will be raised under what conditions ? What is the general correction to be done when this type of error occurs ?
|
|
|
 Ramesh Joyisa |
| Posted: Sep 10, 2007 12:44:07 AM |  |
|
Total Post: 245
Joined: Aug, 2007
|
The RAISE_APPLICATION_ERROR is actually a procedure defined by Oracle that allows the developer to raise an exception and associate an error number and message with the procedure. Raise_application_error is used to create your own error messages which can be more descriptive than named exceptions.
Syntax is:-
Raise_application_error (error_number,error_messages);
where error_number is between -20000 to -20999..
All other numbers belong to Oracle for its own errors. The message can be anything that will fit in a varchar2(2000).
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 843 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gitesh Trivedi | 322 |
| Gopu Gopi | 268 |
| neeraj sharma | 252 |
| Ramesh Jois | 245 |
| Bishal Khetan | 207 |
|
|
