List of value - list seperator
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é