Topic
2 replies Latest Post - ‏2012-05-01T17:27:45Z by SystemAdmin
SystemAdmin
SystemAdmin
2826 Posts
ACCEPTED ANSWER

Pinned topic CLI0102E error when calling stored procedure

‏2012-05-01T16:43:20Z |
We are using the DB2 driver to query our database in a Silverlight app via RIA Services. When attempting to call one of the stored procedures, we are getting this error:

ERROR 07006 IBM CLI0102E Invalid conversion. SQLSTATE=07006

I have verified all the parameters are of the correct type. What could I be missing?
Updated on 2012-05-01T17:27:45Z at 2012-05-01T17:27:45Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    2826 Posts
    ACCEPTED ANSWER

    Re: CLI0102E error when calling stored procedure

    ‏2012-05-01T16:57:04Z  in response to SystemAdmin
    Hi,

    can you please post the exact command you're using the call the SP, as well as the parameter types and sizes.

    Regards,
    Alex
    • SystemAdmin
      SystemAdmin
      2826 Posts
      ACCEPTED ANSWER

      Re: CLI0102E error when calling stored procedure

      ‏2012-05-01T17:27:45Z  in response to SystemAdmin
      Thanks. I started to write all that out, and found that one of my variables was a string where I thought it was an integer. Problem solved!