substring on prompt values

[aetcognos]

Hello gurus,

Is there a way to split the prompt values from a multiselect text box prompt, based on character count.

I am forced to use the oracle INSTR function to compare values from a prompt with a database column. I can use it without issues, but when the no. of characters returned from the prompt exceeds 4000, I get an oracle error that the literal is too long.

So is there a way to split the prompt values to be of 4000 characters each..

Thanks
AETCOG