tancat
asked on
How do I create a Report Builder 2016 dataset based on a procedure or a function with parameters in Oracle?
I am trying to create a dataset in Report Builder 2016 using either a procedure or function in Oracle. The function has three in parameters and returns a sys_refcursor. The procedure has three in parameters and one out parameter (sys_refcursor).
What is the syntax to do this in Report Builder? I have tried both and both "work" (no errors) but I don't know how to handle the resulting sys_refcursor in Report Builder. I can "run" the sql, and I have added fields in "Set Options" but no results, not even headers, show in the result section.
I am an experienced Oracle dev but brand new to Report Builder.
Thank you!
What is the syntax to do this in Report Builder? I have tried both and both "work" (no errors) but I don't know how to handle the resulting sys_refcursor in Report Builder. I can "run" the sql, and I have added fields in "Set Options" but no results, not even headers, show in the result section.
I am an experienced Oracle dev but brand new to Report Builder.
Thank you!
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
ASKER
Open in new window