Re: Printing Data From A Form ??

From: Scott Lawrence <73774.424_at_CompuServe.COM>
Date: 1996/03/17
Message-ID: <4ii2c9$h65$1_at_mhadg.production.compuserve.com>#1/1


If you are using Oracle Forms4.5 you can output the data via the BUILT-IN package TEXT_IO. It has all of the necessary procedures to write to a ascii text file.

If you are not using Forms4.5 you might look into calling a PL/SQL procedure that has the DBMS_OUTPUT package procedures like PUT_LINE to output to a file.

Be careful with DBMS_OUTPUT on any server < 7.3. You can only buffer up to 1MB of data and then it gets truncated. Oracle has a bug that prevents you from "flushing" the buffer.

Try TEXT_IO.

Scott Lawrence
73774.424_at_compuserve.com
VGS, Inc. Received on Sun Mar 17 1996 - 00:00:00 CET

Original text of this message