DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Hybrid View

  1. #1
    Join Date
    Jul 2005

    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.

    Thanks in advance!

  2. #2
    Join Date
    Jun 2005
    London, UK
    I don't know ADO.NET, but does it not have arrays?

    What conversion are you requesting?

  3. #3
    Join Date
    Jul 2005
    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!

  4. #4
    Join Date
    Aug 2002
    Colorado Springs
    I bet you'd find something at http://asktom.oracle.com
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.