I'm trying to create a dataset from an oracle stored proc.The stored proc takes in parameters and generate multiple rows through a OUT ref cursor. BUT when I create a dataset and run it I get ONLY one single row.
My reports need to show data for multiple persons(multiple rows).Some times when I run the data set created from another storpoc I don't get ANY data BUT I get ONLY data set fields(Columns) Why is SSRS behaving such a way with Oracle Stored Procs?
Is it related to Ora 10g version as VS 2005 supports ora 7/8i/9i ONLY?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!