I am trying to execute the Oracle package and Sql query within same dataset in SSRS 2005.
Oracle Package sets Environment variables for the sql query to exucute the query
Oracle package and Sql query as below
select id, m_pck_std_custom.id_desc(id, 1) from M_id
How can i execute the Oracle Package and sql query at once in same dataset of SSRS