Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Please ask technical questions in the appropriate category. Thank you!

Using a PL/SQL refcursor variable as an APEX "Classic Report" source?

m971668May 17 2024

Given this PL/SQL procedure:

PROCEDURE list_my_data
(
out_resultset OUT sys_refcursor
)
AS
BEGIN
open out_resultset for
select
‘A’ as col1
, ‘B’ as col2
, ‘C’ as col3
from dual;
END;
/

How does one use this as the data source for a “Classic Report”?

This post has been answered by InoL on May 17 2024
Jump to Answer
Comments
Post Details
Added on May 17 2024
2 comments
87 views