Close Oracle Report Engine

In the Application development, during running the oracle report engine every time you run the report.

Below is the code to close the reporting engine, if required by the application.

———————————————-
PROCEDURE close_rbe IS

  v_win_handle NUMBER;

  timer_id TIMER;

 

BEGIN

  v_win_handle := win_api_session.findAppwindow(’Reports Background Engine’, ‘rwrbe60.exe’, ‘WINDOW’, WIN_API.WINCLASS_REPORTSSERVER_V6, FALSE);

–  MESSAGE(TO_CHAR(v_win_handle), acknowledge);

 

  IF v_win_handle > 0 THEN

    IF win_api_session.Find3rdPartyApp (’Reports Background Engine’, ‘rwrbe60.exe’, ‘WINDOW’, TRUE, WIN_API.WINCLASS_REPORTSSERVER_V6, FALSE) THEN

      win_api_shell.sendkeys(v_win_handle, ‘%{F4}’, true);

    END IF;

  END IF;

  timer_id := Find_Timer(’Delay’);

  IF NOT Id_Null(timer_id) THEN

            Delete_Timer(timer_id);

  END IF;

  timer_id := CREATE_TIMER(’Delay’, 100, NO_REPEAT);

END;
——————————————————-

step2: call  this procedure in the application to close oracle background reporting engine.
make sure, your application has such requirements.