Dears,

we use a database oracle and store all stored procedures in packages. when using report services I can't deal with packages. if there is any way to open packages

Hi Amer,

It is very much possible to point to oracle packages in SSRS

Please follow the below link

http://blogs.u2u.be/u2u/post/2010/12/16/Using-reporting-services-with-Oracle-package-stored-procedur

Hi Amer,

According to your description, you want to open a Oracle package. Right?

In Reporting Services, since we can only get one result set in when creating a dataset, it's not supported to directly open an Oracle package which contains multiple stored procedures, functions, variables. We can only target on a single stored procedure. And you have to create a cursor to make a Oracle stored procedure return records.

Regards,