Hi Guys, I want help from anyhow.

[GIRIVASAN]

Hi Guys,
I want help from anyhow. I want to send a report to a txt file or excle file directly from the form. Like we can send a report directly from form thourgh add_parameter. is it any add_parameter list is there to send a report directly to txt file or excel file.

Vasn.

 

[vampirus]

You can use text.io of Forms. It open and write an ascii file on the local directory.
Hi by vampiro italiano

 

[GIRIVASAN]

Thanx for ur reply..but can u please tell me in brief..how to use that text.io in forms...
Vasan

 

[vampirus]

this may be an example ...........................

PROCEDURE CALL_REPORT_PARAM ( var_report varchar2) is

out_file text_io.file_type;
plid paramlist;
the_param varchar2(15) := 'tmpdata';


BEGIN
OUT_FILE := TEXT_IO.FOPEN('SALVA.BAT' ,'W');

VAR_STRINGA := 'XCOPY ' || VAR_STRINGA_FILE || ' A:\';

TEXT_IO.PUT(OUT_FILE, VAR_STRINGA);
TEXT_IO.FCLOSE(OUT_FILE);
end;