On 18-7-2014 14:00, 'checkmail' check_mail@... [firebird-support]
wrote:

> If I use the following code to extract a part of a string, it works fine:
>
> s_datum = substring(:dat from 13 for 4);
> s_datum = char(4)
>
> Now I would give the same a stored procedure, the first input parameter
> is XXX varchar(30), it returns me the integer-value and the status
> (passed or not)
>
> select int_out, status from P_u_cn_to_int(substring(:dat from 13 for 4))
> into :i_z1, i_status1;
>
> The second thing – it does not work – why? If I set the input-parameter
> to ‘1234’, it works, but the substring?

"It does not work" is a bit vague. What is the value of dat, and what is
the result of the substring? Does it match the expectations of the
stored procedure?

Mark
--
Mark Rotteveel