Forum Discussion
Anonymous
2 years agoNot applicable
Run multiple parameter Oracle SYS_REFCURSER Stored Procedure in Power BI and Paginated Report
Hi DEV,
I need to develop a Paginated Report using Oracle data source and getting data from multiple parameter SYS_REFCURSER Stored Procedure.
My SP looks like:
CREATE OR REPLACE PROCEDURE "SP1" (
variable1 IN [Schema].[Table].[Column]%Type,
variable2 IN [Schema].[Table].[Column]%Type,
myCursor OUT SYS_REFCURSER
)
IS
rc SYS_REFCURSER;
BEGIN
OPEN rc FOR
[SQL QUERY];
MYCURSOR := RC;
END;
I am new with oracle and need help with syntax on how to call this in Power BI and Paginated report?
No Replies