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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 16 2013

Added on Dec 19 2012

#bi, #business-intelligence-applications, #oracle, #publisher

0 comments

502 views