Hi,
I have a use case where i need to pass list of comma seperated values(more than 1000) to a bind variable of a view object query set in programmatic where clause. I have used INSTR func for passing list of comma seperated values, but i think it(INSTR func) has some limitation i.e.list size should not become more than 4000 byte.
In my case INSTR work fine when i pass 400-500 or 700 comma seperated values, but when my list exceeds than 1000, it starts throws an
oracle - ORA-01460: unimplemented or unreasonable conversion.
Thanks