Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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