passing parameters [message #516720] |
Wed, 20 July 2011 04:38 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/69befe204ef85a9fb166538cf3baa36c?s=64&d=mm&r=g) |
jo28
Messages: 1 Registered: July 2011
|
Junior Member |
|
|
Hi,
In my application (forms6i) initially data will be displayed in a non-database block after a lot of calculations and validations
which is time consuming.
Now, if the user want to print it as a report, we store the displayed data in a dummy table and run the report using that dummy table and then delete records from it.
Is it possilbe to pass the records displayed to the report as a parameter so that I can avoid un-necessary add/delete records?
Please help
|
|
|
Re: passing parameters [message #516922 is a reply to message #516720] |
Thu, 21 July 2011 07:49 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
yeahia
Messages: 22 Registered: June 2010 Location: Bangladesh
|
Junior Member |
|
|
you can pass the filed as parameter but not the record. you can try with this:
PROCEDURE Print_Report IS
opt varchar2(200);
pl_id ParamList;
BEGIN
pl_id := Get_Parameter_List('tmpdata');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List('tmpdata');
opt:='\\Reports\NFD_Production.REP';
Add_Parameter(pl_id,'date_from',TEXT_PARAMETER,:date_range.date_from);
Add_Parameter(pl_id,'date_to',TEXT_PARAMETER,:date_range.date_to);
Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
Add_Parameter(pl_id, 'DESTYPE', TEXT_PARAMETER, 'SCREEN');
Run_Product(REPORTS, opt, SYNCHRONOUS, RUNTIME,
FILESYSTEM, pl_id, NULL);
END;
yeahia
|
|
|