You are on the right track here - to return a result set from an Oracle stored procedure you need to declare an output parameter of type sys_refcursor. Here is a sample stored procedure that retrieves some data from the sample scott/tiger schema:
dept.deptno = emp.deptno
The steps how to setup the stored procedure in SqlDataSource Wizard are described in the following help topic from the online documentation: SqlDataSource Wizard
. Just remember on the Configure Data Source Command page to choose the Stored Procedure option and pick your stored procedure from the drop-down list. A common mistake made by some users is to specify the name of the stored procedure in the text area below the Select Statement option, which would not produce the desired result, because SqlDataSource would treat that as a regular select statement and fail to execute it. Please, check the attached sample report which demonstrates this. You might need to modify the connection string in the SqlSataSource component to reflect the location where your Oracle database is installed.
Additionally make sure that the used OLE DB provider supports the Oracle-specific type sys_refcursor.
the Telerik team