Report based on Oracle Package

I want to use the results of a stored procedure from an Oracle package as my source for a report. But the stored procedure isn't listed on the dropdown when I try to add it, even though it's listed under "Procedures" in the server explorer with the [package name].[procedure name] format, but when I try typing that I just get a procedure does not exist message.You can do this programatically by loading the results into a dataset, and loading the dataset into the report. Cheers!|||Thakns. I'm pulling from five tables, so I guess I'd best get started.|||

I've created the dataset, and I can bind it to a grid, but I'm having trouble using it as a datasource for my report.

I used

ReportViewer2.LocalReport.DataSources.Add(New ReportDataSource("ds"))ReportViewer2.DataBind()

but then if I use =!Fields.LAST_NAME.Value in my table on my report I get a "report has no dataset" message and if I use =(!Fields.LAST_NAME.Value, "ds") I get the same.

Suggestions?