1 Reply Latest reply: May 2, 2011 8:11 AM by dmcghan RSS

    Bug: Intermittent issue with APEX_PLUGIN_UTIL.GET_DATA2

    dmcghan
      Hello,

      A user recently reported a bug with the Super LOV plug-in that occurred while querying a collection. The issue was that if the page loaded/refreshed a few times within a few seconds, the following exception was raised:

      ORA-01007: variable not in select list
           Error      Error in PLSQL code raised during plug-in processing.

      The user set up a test at...
      workspace: MARILYN_WORKSPACE
      application: 15778
      page: 1

      I was able to isolate the issue to a call to GET_DATA2. For some reason the function call runs successfully a couple times but eventually fails with the reported exception. I'm not sure what could be causing the issue...

      Regards,
      Dan

      Blog: http://danielmcghan.us/
      Work: http://skillbuilders.com/apex/