Hello,

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?

Thanks in Advance

Best regards

Olaf