ORA-01722: invalid number in Multiple Select in BI Publisher
978906Dec 19 2012 — edited Dec 19 2012Hi all,
We are using BI Publisher v10.1.3.4. We have a parameter , we have enabled multiselect and the parameter looks like
*'EN 60730-1:2000/A1:2004, EN 60730-2-14:1997, EN 60730-2-15:1995, EN 60730-2-3:2007'*
When we select one value as the parameter, it works fine but when we select more than 1 values, then it throws* ORA-01722: invalid number*. We are using string datatype for the parameter. Someone kindly share your experiences.
Edited by: 975903 on Dec 19, 2012 2:47 AM