Forum Discussion
Paginated Report - Measure and Recordset From Query consideration
Hallo, i'me newbie in Power BI and i've 2 questions: I've PRO License. 1. Is possibile with a Paginated Report (.rdl) obtain data from Oracle Store Procedure that return SYS_REFCURSOR passing one ...
Ok. Thanks for all.
Last dubt:
I understand that object type in oracle is not requested.
Then in the text edit of Report Builder i can use something like this:
Select PKG_POWERBI.MyFunc(:DataRif) as RESULT FROM DUAL or
Select PKG_POWERBI.MyFunc(:DataRif) FROM DUAL or other ?
Thanks again.
Hi FrancoCNR ,
No, you cannot use SELECT PKG_POWERBI.MyFunc(:DataRif) FROM DUAL.
A function returning SYS_REFCURSOR does not return a scalar value and cannot be selected from DUAL
The supported approach is to expose the cursor as a table source and query it using
SELECT *
FROM TABLE(PKG_POWERBI.MyFunc(:DataRif))
Thakns,
Prashanth