Invalid Column Type Error
Hello All,
I have a problem in BI Publisher in case of selecting multiple
values from filters.I am passing the values to a function in pl/sql.
ex : i have a parameter(filter) say "account_no" for which multiple select option is enabled.So i can select multiple values while viewing.Then in the query what i did is like i am passing this "account_no" as one of the parameter to a function in PL/SQ L .If I am selecting All values using can select All option it is working fine and for single value also it is working fine.But, In case of multiple values it is showing error like :
ex : i have a parameter(filter) say "account_no" for which multiple select option is enabled.So i can select multiple values while viewing.Then in the query what i did is like i am passing this "account_no" as one of the parameter to a function in PL/SQ L .If I am selecting All values using can select All option it is working fine and for single value also it is working fine.But, In case of multiple values it is showing error like :
0