Home » Developer & Programmer » Forms » DBMS_OUTPUT.ENABLE (100000)
DBMS_OUTPUT.ENABLE (100000) [message #181354] Sun, 09 July 2006 02:05 Go to next message
Malan_72
Messages: 5
Registered: June 2006
Location: Karachi
Junior Member
What does theDBMS_OUTPUT.ENABLE (100000); do in forms 6i?

Malan
Re: DBMS_OUTPUT.ENABLE (100000) [message #181393 is a reply to message #181354] Sun, 09 July 2006 14:04 Go to previous messageGo to next message
Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
DBMS_OUTPUT is usually used in PL/SQL programs (when run in SQL*Plus, TOAD, SQL Developer, etc.) to display user messages (and, therefore, can be used while debugging the code). It is not adviced to use it instead of raising errors in exception handlers.

In Forms Builder, I never used DBMS_OUTPUT; when necessary, I use either MESSAGE or ALERT to communicate with end user.

As DBMS_OUTPUT can be used in PL/SQL block, I guess this line wouldn't raise compilation error, but also don't know what it does in Forms.
Can you search through this form for another appearance of DBMS_OUTPUT package? Is there any DBMS_OUTPUT.PUT_LINE there, for example? Where?
Re: DBMS_OUTPUT.ENABLE (100000) [message #181419 is a reply to message #181393] Mon, 10 July 2006 01:01 Go to previous message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
DBMS_OUTPUT does nothing in Forms, apart from a database roundtrip to verify it's exisctence. The calls are valid but useless in Forms.

MHE
Previous Topic: how can i extract the time in forms from date field?
Next Topic: View Query
Goto Forum:
  


Current Time: Fri Sep 20 09:38:35 CDT 2024