Run report cursor stays busy
We are using Oracle Forms & Reports 11g
We have a procedure that is called each time we want to send a report job request to report server.
Before we call RUN_REPORT_OBJECT, we set cursor state to busy:
SET_APPLICATION_PROPERTY(CURSOR_STYLE, 'BUSY');
After we check REPORT_OBJECT_STATUS to be not IN ('RUNNING','OPENING_REPORT','ENQUEUED') states, we set cursor state to default:
SET_APPLICATION_PROPERTY(CURSOR_STYLE, 'DEFAULT');
However, there are some cases on some users' PC where the cursor state remains busy.
Could it be due to IE or PDF settings ?