Home » Developer & Programmer » Forms » difference b/w dbms_output and raise_application...
difference b/w dbms_output and raise_application... [message #305317] Mon, 10 March 2008 07:07 Go to next message
Messages: 3
Registered: March 2008
Location: chennai
Junior Member
what is the difference between dbms_output and raise_application
Re: difference b/w dbms_output and raise_application... [message #305328 is a reply to message #305317] Mon, 10 March 2008 07:58 Go to previous message
Messages: 20848
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator

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.
Previous Topic: Forms 10g Rel 2 is not connecting oracle
Next Topic: maximising forms 10g
Goto Forum:

Current Time: Fri Oct 21 12:29:28 CDT 2016

Total time taken to generate the page: 0.11932 seconds