OraFAQ Forum: Forms » Forms get hanged when close calling a report

Home » Developer & Programmer » Forms » Forms get hanged when close calling a report

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Forms get hanged when close calling a report [message #330312]

Sun, 29 June 2008 06:16

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

Report message to a moderator

Re: Forms get hanged when close calling a report [message #335900 is a reply to message #330312]

Thu, 24 July 2008 02:15

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.

Report message to a moderator

Previous Topic:	DATE CHECKING
Next Topic:	how to display stored PDF file in forms 6i ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 01:46:35 CDT 2025