Re: Report Background Engine Still will not close!

From: MarkyG <markg_at_mymail.tm>
Date: 6 Dec 2001 02:04:41 -0800
Message-ID: <ab87195e.0112060204.363c6c34_at_posting.google.com>


[Quoted] I *think* on a Client - Server environment, at least one has to be left open.

Anyway, it will be more efficient if it is left open otherwise it has to recreate the engine every time a report is run.

Browse through MetaLink at www.oracle.com, support section, for more info.

Mark

avril7_at_yahoo.com (Av) wrote in message news:<4c29054a.0112041301.756df9c9_at_posting.google.com>...
> I have been successful in using the ORACLE_SHUTDOWN parameter to close
> the report engine, on my PC. The problem is, the production
> application is installed on a terminal server through which the users
> access the application, and when i run the report from the terminal
> server, the engine remains open.
>
> Here's my code:
>
> BEGIN
> pl_id := Get_Parameter_List('tempdata');
> IF NOT Id_Null(pl_id) THEN
> Destroy_Parameter_List( pl_id );
> END IF;
>
> pl_id := Create_Parameter_List('tempdata');
> Add_Parameter(pl_id, 'ORACLE_SHUTDOWN', TEXT_PARAMETER,'Yes');
> RUN_PRODUCT(REPORTS,'TESTS',SYNCHRONOUS,RUNTIME,FILESYSTEM,pl_id,'');
> END;
>
>
> The report builder versions on the terminal server and my PC are the
> same - 6.0.5.28.0
>
> Please tell me why this is happening? Any help will be greatly
> appreciated.
>
> Thanks
> Av
Received on Thu Dec 06 2001 - 11:04:41 CET

Original text of this message