""lobolo2000"" <lobolo2000@...> schrieb im Newsbeitrag
news:045b01c0ff8e$f3570820$6f3efea9@supradpt...

> 1- I have declared a variable in a stored procedure:
> DECLARE VARIABLA EOL CHAR(2);
> EOL=ASCII_CHAR(10)||ASCII_CHAR(13);
> but i keep getting the message: 'Arithmetic exception, numeric overflow,

or

> string truncation'
> Even using EOL=ASCII_CHAR(10); produces the error, which leads me to think
> that the problem is with the ASCII_CHAR UDF. What could be wrong?

Did you tried to set variable EOL to Length 13?
--

Regards,
Tilo Muetze