Hi ,
I am trying to pass report parameters to an oracle query.....by using this query in sql data source
select *
from customer
where
(CustomerShop=:v_customer_Shop)
When I try to pass in value to the V_customer_shop it does not return any records even though it has records in the table.
I am passing the v_customer_shop as String type should i change that..Is there a special string type for oracle parameters..Please guide me..
Thank you
I am trying to pass report parameters to an oracle query.....by using this query in sql data source
select *
from customer
where
(CustomerShop=:v_customer_Shop)
When I try to pass in value to the V_customer_shop it does not return any records even though it has records in the table.
I am passing the v_customer_shop as String type should i change that..Is there a special string type for oracle parameters..Please guide me..
Thank you
1 Answer, 1 is accepted
0
Ravi
Top achievements
Rank 1
Rank 1
answered on 25 Jul 2012, 04:35 PM
Sorry but got my problem resolved..It was database issue...