APEX

I have a pl/sql function that returns a SELECT statement based on very flexible query specifications allowed in a form. (Form allows operations like <,>,between, etc, that can be entered directly into the field; all fields need not have some sort of query constraint specified. Essentially the same sort of query flexibility you get in Forms... ) The select always returns the same number of columns. Query results are returned on a different page (either report or tabular form) than the form used to enter the query specs.

The function works beautifully on a page type of Report.

However, when I take a Tabular Form and switch its query source to PL/SQL function body returns SQL select, the page type becomes Report. The query works on this modified page (returns correct rows), and the columns are still editable (can be typed into) but the changes can't be submitted because the page is no longer a tabular form -- Error is: No updateable report found. Multi row updated and delete operations can only be performed on tabular forms of type 'Updateable Report'.

How can I have flexible query specs paired w/ tabular form? Does this require writing my own multi-row DML processes? Or is there a simpler way?

Thanks,
Carol