Announcement

Collapse
No announcement yet.

OTM 6.4 BI reports with more than one values for a bind variable separted by comma

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • OTM 6.4 BI reports with more than one values for a bind variable separted by comma

    Hi folks,
    Has anyone created any BI publisher reports in OTM 6.4.1 BI publisher passing more than one valued a bind variable separated by comma.

    Scenario is , I want to generate a report by passing more than one order source locations. I have used below filter condition in the query.

    ORR.SOURCE_LOCATION_GID in (SELECT REGEXP_SUBSTR(:P_SOURCE_LOC,
    '[^,]+',
    1,
    LEVEL
    )
    FROM DUAL
    CONNECT BY LEVEL <= LENGTH (:P_SOURCE_LOC)
    - LENGTH (REPLACE (:P_SOURCE_LOC,
    ',') ) + 1)
    It runs find in the DB and BI publisher but if I run it from OTM it gives me error as,
    ORA-00909: invalid number of arguments --
    Any idea on how it could be used.

    Thanks,
    Sandip
Working...
X