Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to disable scrollable cursor in OBI EE?

703858May 27 2009 — edited May 29 2009
Hi, i'm using OBI EE 10.1.3.2 and did some simple quey by just selecting 3 columns without any grouping whatsoever from our datamart on postgresql 8.2. Somehow OBI EE generate a scrollable cursors and generate ODBC error that say the database didn't support a scrollable cursors. We cannot upgrade the database so we need to do something with OBI EE.

Do you know how to disable OBI EE to generate a scrollable cursors ? i check the OBI EE Administration and go to the tab (in the physical layer) with "ask dbms" button and cannot find any cursors setting. It is a normal SELECT so i don't need a scrollable cursors.

thank you before
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details