| Kill the Report Background Engine [message #135904] |
Sun, 04 September 2005 08:15  |
sarfraz_attari
Messages: 123
Registered: July 2005
|
Senior Member |
|
|
Is there any way to kill the report background engine after the report is generated
i tried ORACLE_SHUDOWN = 'YES' but it is not shutting down report background engine
i tried to change the registry entry also but still it is same
I want to know is there any operating system command to close background engine
I am using Windows 2000 and Developer 6.0
thanks
sarfraz
|
|
|
|
| Re: Kill the Report Background Engine [message #136035 is a reply to message #135904] |
Mon, 05 September 2005 09:00  |
magnetic
Messages: 324
Registered: January 2003
|
Senior Member |
|
|
there you go...
an example how to kill the engine..
i use this in a form wich runs a report..
this will kill the engine when the form closes/exits..
so you need to call this procedure in triggers like when-window-closed..
------
PROCEDURE close_report_engine IS
BEGIN
declare
pl_id paramlist;
begin
pl_id :=get_parameter_list('paramName');
if not id_null(pl_id) then
destroy_parameter_list(pl_id);
end if;
pl_id :=create_parameter_list('paramName);
add_parameter(pl_id,'ORACLE_SHUTDOWN',text_parameter,'YES');
run_product(REPORTS,'DUMMY_TEXT',ASYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,null);
end;
END;
------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
