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

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

    Re: CLI0102E error when calling stored procedure

    ‏2012-05-01T16:57:04Z  
    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

    Re: CLI0102E error when calling stored procedure

    ‏2012-05-01T17:27:45Z  
    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
    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!