I've searched the forums for help and can't quite place my finger on the answer.
What I am developing is a dynamic manual fetch row procedure and/or function (they both return the same varchar string) that returns the manual fetch row string. The returned string will be used as a after header process the output it looks like this using htp.prn:
FOR C1 IN (SELECT <column_names> FROM <table> WHERE <pk_conditions>)
LOOP
:PX_<item> := C1.<column_names>;
END LOOP;
Of course if you follow the documentation we learn that a manual fetch row can be written as above and used as the PL/SQL anonymous block region, perfect!
I have tried various options like setting the value and calling a hidden page item, creating a "on-demand" application process, and trying to call a function.
I always get this error:
PLS-00372: In a procedure, RETURN statement cannot contain an expression
Is there any way to create a APEX process that uses a function?
Is there any way to have the procedure string return to the application process and run?
I expected this to be more simple and hope its somthing small I am missing.
Thanks in advance,
Mike