7 Replies Latest reply on Apr 5, 2012 3:02 AM by 715694

    ORA-29983: Unsupported query for Continuous Query Notification

    User642477-Oracle
      Hi, i'm having a LOV with auto refresh. If i add "Order by " to the LOV query , the following exception is thrown.


      SQL error during statement preparation. Statement: SELECT * FROM (SELECT DISTINCT XXXX FROM YYYY) QRSLT ORDER BY "XXXX"
      Error     ORA-29983: Unsupported query for Continuous Query Notification

      I tried to override the create method of the VO, with "this.setNestedSelectForFullSql(false);" .. But this one disables the auto referesh property...

      Could some one help to solve this. Thanks .