Oracle collection plan error
Hi,
We're getting below error while entering data in some collection plan. And if we check the collection plan set up, while opening that specific 'Collection Element' in which we are trying to enter values, we are getting error as ""frm-40105 unable to resolve reference to item Q_RES. DISPLAY1."
Below is the screen shot for collection plan set up;
and in action details below SQL is used;