BI Publisher (MOSC)

MOSC Banner

List of value - list seperator

edited Jul 7, 2014 2:29PM in BI Publisher (MOSC) 4 commentsAnswered ✓

Hi,

I do have a question about the LOV and more specifically on the list separator.  When I'm selecting more than one value, the list return contains ";" semicolon instead of the regular "," comma.  So when I'm using ":MyParam" in my SQL I'm getting an ORA-00909 Invalid number of arguments.

My Where clause:  LMCO IN :Project OR LMCO = nvl(:Project, LMCOO)

The LOV is working well if I only select one value or ALL (passed as null).

Thank you.

André

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center