Java Development Tools

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 the query optimizer

GPS-OracleNov 4 2010 — edited Jan 13 2011

Hi, i'm having a simple query to populate a lov with auto refresh. At run time the query optimizer adds key word "LIKE", which can not run in guaranteed mode.

So i'm looking for the options to solve the issue. Can some one point me how to disable the query optimizer . So that the query will be same as in VO.

OR how to set the query in best-effort-mode to avoid, "ORA-29983: Unsupported query for Continuous Query Notification". thanks .

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 10 2011

Added on Nov 4 2010

#adf, #application-development-in-java, #jdeveloper, #jdeveloper-and-adf, #table

17 comments

1,455 views