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: 21151
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: auto generating a serial number on a form's multi record block
Next Topic: date
Goto Forum:

Current Time: Thu Aug 24 00:07:35 CDT 2017

Total time taken to generate the page: 0.07495 seconds