Reports Builder wont open in Windows 10 64bit - [SOLVED]

Though Oracle doesn't support Forms 10g in Windows 10: 64 bit, I had installed it and was working till last month. Then suddenly one fine day, the report builder window won't show up. Though it was running in the task bar, I couldnt do anything with it. Forms builder was working properly.

Then taking cue from this Oracle form community post, I copied the cauprefs.ora from my colleague. Boom, the Report builder started to show up.

Then spend some time analyzing changes of the backup file with my file obtained from my colleague. It showed differences in the section where x, y coordinates were saved for Reports preferences.

====cauprefs.ora Backup file (Report Builder not opening)
Reports.root_ht = 725
Reports.root_max = No
Reports.root_wd = 1333
Reports.root_x = "-32000"
Reports.root_y = "-8"
Reports.root_y = "-32000"

====cauprefs.ora from my colleague (Report Builder opening properly)
Reports.root_ht = 725
Reports.root_max = No
Reports.root_wd = 1333
Reports.root_x = "-8"
Reports.root_y = "-8"
Reports.root_y = 0

The highlighted lines were causing the problem, and once replaced my problem is solved.

Reuse and Show Apex's Wait Popup

Oracle Apex supports or offers a GIF image and an overlay while loading content using Dynamic Action/AJAX. While creating a dynamic action you have an option to select "Show Processing" for supported actions.

This shows a nice overlay over the screen and a GIF image out of the box. You may have scenarios to show a loading while doing some javascript/jquery actions on your own.

Will it not be nice to show/reuse the same overlay and image?

This article explains how to do it.

Say you have a function to load data from server and show on page using a javascript function:

function previewFiles(){

The above javascript call will show the overlay and GIF image. This is very simple isn't it. But to hide it, there is no function. We have to call following jquery method calls.


Which will remove the popup and overlay from DOM. To simplify things we will create this as a javascript function and save in one's library.

function hideWaitPopup(){

Then simply call hideWaitPopup(); inside your javascript function to hide the popup and overlay.

Inserting DBMS_OUTPUT from wrapped procedures into a table

This tip is courtesy +V. Kapoor from Thank you, you saved my day.

I had a situation where the database procedure SRW is wrapped and I needed to log the dbms_output.put_line output produced by the package into a table. Thanks to the tip provided, I was able to do so.

I had to call the following procedure

dbms_output.get_lines(vcol, n);

This procedure is intended to retrieve an array of lines from buffer. This means if the buffer is not cleared it will be available in the array (out parameter 1). The second parameter is the number of lines in array returned by the procedure.

To declare the OUT variables required by this procedure do the following:

n number;
vcol dbms_output.chararr;

Simply put together the code will be as follows:

   n      NUMBER := 100;
   vcol   DBMS_OUTPUT.chararr;

   --- get the output into vcol array
   DBMS_OUTPUT.get_lines (vcol, n);

   FOR i IN 1 .. n LOOP
      INSERT INTO log_table (char_col, procname, log_date) VALUES (vcol (i), USER, SYSDATE);