0 Replies Latest reply: Dec 19, 2012 4:47 AM by 978906 RSS

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

    978906
      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