Error ORA-01460: unimplemented or unreasonable conversion requested
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.
Well, maybe that's the issue. I don't really know ADO.NET either - the developers are having a difficult time accessing the stored procedure. I am new to Oracle but have done much development in SQL Server. In SQL Server, since there is no array data type or anything to pass in multiple values into one parameter, I use a comma separated list and use a function to parse the list. I was doing the same in this stored procedure. Are there some good references out there for passing an array as an input parameter in PL-SQL?? Thanks so much!