I hve created one procedure in oracle which is used as a dataset 1 in SSRS
in oracle procedure we created one table which is used in sql server query as a dataset 2.
but after click on refresh button it gives proper resultset. can we get proper data without clicking on refresh button?
i have read some solution from related topics
solution is execute oracle procedure as command type text in SSRS.
but how to execute oracle procedure as command type text in SSRS.
Thank in advance