i am developing datareports with data environment and backend as oracle 9i.
i have to use the query like ‘select * from det where name in (parval)’
but im not able to pass multiple values to parval like parval=23,34,45 or parval=’23’,’34’,’45’.it is not accepting.
but the same query runs well from oracle 9i sql prompt.
do anyone have an idea of how to pass multiple values to a datareport command parameter?
thanks in advance
