Skip to main content
K
kirans0126
July 19, 2023
Question

Execute store procedure to update data

  • July 19, 2023
  • 7 replies
  • 0 views

Hi All,

I am trying to update data from one table to other table using execute store procedure smart service but i am getting below error while executing smart service.

(conn=8566693) Incorrect string value: '\xAC\xED\x00\x05ur...' for column.

can any one suggest what it is referring for.

 

Thanks in Advance

    7 replies

    mikes0011
    mikes0011
    Brainy
    July 19, 2023

    Sounds like you're trying to insert some text with advanced features (unicode / emojis / etc) into a text column that can't handle it.

    The Expression Guru
    K
    kirans0126Author
    July 19, 2023

    Hi Mike,

    I am not writing any emojis or Unicode just text values writing it from one table to other table using sp.

    and I am passing parameters to sp through pv in process model

    (if i execute sp manually in data base and pass the parameter it is working fine & facing issue while using execute sp smart service).

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    July 19, 2023

    Sharing some code might help us to support you.

    Terms & ConditionsAccessibility statement