Link to home
Start Free TrialLog in
Avatar of tancat
tancatFlag for United States of America

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!
Avatar of tancat
tancat
Flag of United States of America image

ASKER

Using the function example:
declare
  p_record_set sys_refcursor;
begin
  p_record_set := schema_name.func_name('string',number,'string');
end;

Open in new window


This question needs an answer!
Become an EE member today
7 DAY FREE TRIAL
Members 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.