Home » Developer & Programmer » Forms » Forms get hanged when close calling a report
Forms get hanged when close calling a report [message #330312] Sun, 29 June 2008 06:16 Go to next message
elsy
Messages: 40
Registered: August 2006
Location: Kuwait
Member

Dear Friends

We are using oracle forms 6i and report6i ,
When I call oracle reports6i rep file through forms6i (Press Button )
Its will open properly , when I close that Report my application get hang up

And cursor not get back to forms

Written below is the code

pl_id:=Get_Parameter_List('Reportparm');
IF NOT id_null(pl_id) then
Destroy_parameter_list(pl_id);
END IF;
pl_id:=create_parameter_List('Reportparm');
add_parameter(pl_id,'ORACLE_SHUTDOWN',text_parameter,'Yes');
Add_Parameter(pl_id,'PARAMFORM',TEXT_PARAMETER,'NO');
Add_parameter(pl_id,'inv_no',text_parameter,:control.inv_no);
Add_parameter(pl_id,'brid',text_parameter,:control.brid);

run_product(Reports,'invoice',synchronous,runtime,filesystem,PL_ID,null);




Can anyone has faced the same problem...

Please help

Thanks


Re: Forms get hanged when close calling a report [message #335900 is a reply to message #330312] Thu, 24 July 2008 02:15 Go to previous message
gurupatham
Messages: 66
Registered: March 2008
Location: Chennai
Member
if possible ,
Use asynchronous instead of synchronous in run_report method.
because when you use synchronous , you cannot work in the form when report is running.
control will not come to the form until the reports get closed.
but when you use asynchronous , both will work separately . they are independent.

it may be one of the reason to hung.
Previous Topic: DATE CHECKING
Next Topic: how to display stored PDF file in forms 6i ?
Goto Forum:
  


Current Time: Mon Dec 05 12:53:53 CST 2016

Total time taken to generate the page: 0.12072 seconds