Fellows,

When I run select below:

SELECT
' até ' || DATETOSTR(VALIDADE_ATE, '%d/%m/%Y')
FROM TABELA

It works fine.

When I run the command below in store procedure:
VALIDADE = ' até ' || DATETOSTR(VALIDADE_ATE, '%d/%m/%Y')

Result this error:
"arithmetic exception, numeric overflow, or string truncation -
Cannot transliterate character between character sets"

I replace the character "É" to "E" in store procedure and it works fine.

Could someone help me?
I'd appreciated that.

Sorry my poor English, I'm studding! :D


Thanks.