SSRS Multiple Data Sources Issue

Question

I am have scenario where there is a need to pull & compare data from two different data sources. One is a oracle & other is MS Sql

I need to match both ID column from both data sources. I am passing MS sql data as a parameter to the oracle dataset.

 I am using OLE DB for both oracle & sql data sources. I have checked around the native driver options as well.

I am able to preview data in both data sets individually

 However when i validate oracle query, its not passing successfully as its not able to pass sql parameter.

Error Screenshot:

Request to help resolve this.

Answer 1

anybody can please help in this regard ?