This discussion is archived
1 Reply Latest reply: May 2, 2011 6:11 AM by dmcghan RSS

Bug: Intermittent issue with APEX_PLUGIN_UTIL.GET_DATA2

dmcghan Oracle ACE
Currently Being Moderated
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/