APEX

Hi everyone! I'm getting an error and not much luck searching google or on here for suggestions on what to do...

I have a tabular form and I changed my field to be a Select List.

I've changed the List of Values Type to be PL/SQL Function Body returning SQL Query, with a source of:

return xxpu.pu_apex_lov_pkg.get_buyer('N');

This is a function that returns sql in a varchar.  I've used this method for years.  Now I'm getting this error...any ideas? We just upgraded to 5.1:

ORA-20999: 'PL/SQL Function Body returning SQL Query' List of Values not supported for this type! ORA-06512: at "APEX_050100.WWV_FLOW_REG_RPT_COL_DEV_IOT", line 79 ORA-04088: error during execution of trigger 'APEX_050100.WWV_FLOW_REG_RPT_COL_DEV

If I run the function and put the sql in it's place it works fine, so I guess that's what I'll do for now, but defeats the purpose of having it in one place (the package) to easily maintain.

Here is the sql returned by the function:

  select xxpu.pu_util_pkg.pu_get_buyer_name(agent_id) disp

                   , agent_id   ret      

               from po.po_agents  pa order by disp

I did try creating this form originally as an Interactive Grid but I kept getting Ajax/No Data Found errors so I've given up and gone back to the Tabular Form just so I can this project done soon...I did the same thing there for a Select List column and I did not get this error.

Thanks,
Janel