Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01722: invalid number in Multiple Select in BI Publisher

978906Dec 19 2012 — edited Dec 19 2012
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 16 2013
Added on Dec 19 2012
0 comments
500 views