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?
May 27, 2008 1:08 AM
July 14, 2009 8:19 AM