Oracle Forms (MOSC)

MOSC Banner

Run report cursor stays busy

in Oracle Forms (MOSC) 3 commentsAnswered

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 ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center