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
