amar on web

dbms_output.put_line affect on Forms 6i

Does using DBMS_OUTPUT package in the back-end routines have any impact on the Front-end?
We normally use DBMS_OUTPUT.PUT_LINE to display messages in our code, which is handy when debugging using SQL*Plus. We don't encounter any issues when such back-end routines are called in Forms.

Is there any situation where use of DBMS_OUTPUT can generate error when Forms is running?

DBMS_OUTPUT is disabled by default when forms is running. If this option is explicitly enabled, using DBMS_OUTPUT.ENABLE, then it will behave the same way in forms, as it would in the back-end. Though the output will not be shown, but if any error is encountered, it will be thrown to the user in the front-end. The most common errors related to this package use are:

 ORU-10027: buffer overflow, limit of  bytes 
 ORU-10028: Line length overflow, limit of 255 bytes per line. 
So, don't be surprised if these error show up on your front-end screen.

Best viewed in medium text size. Please refresh this page (F5) to view the latest information.
This page was created on 15-dec-2000 and last updated on 27-dec-2006.
please forward all queries to [email protected]