shraddha.sawant 0 Newbie Poster

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.