|
Re: difference b/w dbms_output and raise_application... [message #305328 is a reply to message #305317] |
Mon, 10 March 2008 07:58  |
 |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Huge.
DBMS_OUTPUT will only display a message in a client tool which is capable of doing so (SQL*Plus, TOAD and similar) and only if you have enabled SERVEROUTPUT. Otherwise, you (or anyone else) will see nothing. Besides, I hope you don't expect your users to use the application via SQL*Plus.
RAISE will raise an error everywhere - in SQL*Plus, but in Forms application and other GUI-oriented ones as well. Forms will, for example, fail and you'll be able to view the message in the "Help - Show error" menu.
|
|
|