I have a Stored proc that receives a VARCHAR parameter which is a comma separated list of values. I send that parameter inside a function with VARCHAR2(32767) datatype. When executing the stored proc in ADO.NET I get the Error ORA-01460: unimplemented or unreasonable conversion requested error. How do I declare the input parameter that is going to be passed into the stored procedure. The size of the variable could be extremely large.

Thanks in advance!