1 Reply Latest reply on May 2, 2011 1:11 PM by dmcghan

    Bug: Intermittent issue with APEX_PLUGIN_UTIL.GET_DATA2


      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...


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