Call Oracle Store Procedure from Reporting services
Can u please tell me how to call a oracle stored procedure that accepts 2 in parms and returns a Ref cursor as out parameter exmple:CREATE OR REPLACE PROCEDURE GetReportData( Id1 IN NUMBER, Id2 IN NUMBER, resultSet OUT sys_refcursor )
View Answer
| Sep 30 2008 2:56 PM GMT
| asked by
PramodSR
REF CURSOR, Oracle stored procedures, Oracle reporting
Using Oracle 10g Stored proc in SSRS 2005
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...
View Answer
| May 27 2008 1:08 AM GMT
| asked by
Ala10ala
Oracle stored procedures, Oracle 10g, SQL Server Reporting Services
