The conversion from UNKNOWN to UNKNOWN is unsupported.

I am getting this error while executing stored procedure function.

  Discussion posts and replies are publicly visible

Parents
  • +1
    Certified Lead Developer
    Hello Mayank,

    That for sure has to do with the parameters you are sending to the store procedure. Can you share how you have the parameters in the SP and what are you sending?

    That can happen if you try to pass strings to a native type in the SP. you can try to pass/receive everything as string/catcher and then cast on the SP.

    special note the native types include char, don’t expect the string to be casted to a char.

    Hope this helps
    Jose
  • 0
    A Score Level 1
    in reply to josep

    Hi josep,

    I agreed with you and I had figured out that problem but it gives another error for

    Use the Execute Stored Procedure Smart Service to modify data. This function must only be used to query data, not modify.

Reply Children