Hi, it might be the bug 4572934 depending on the version you are using.
Try the following code:
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| DECLARE
v_ret_date CHAR(8 BYTE); -- this fails in 10g
-- v_ret_date CHAR(8); this works
PROCEDURE proc2(o_ret_date OUT CHAR )
IS
BEGIN
o_ret_date := to_char(SYSDATE, 'YYYYMMDD');
END ;
PROCEDURE proc1 (o_ret_date OUT CHAR)
IS
BEGIN
proc2 (o_ret_date);
END;
BEGIN
proc1 (v_ret_date);
END;
/ |
moi
Citation:
Hi,
Actually, by changing the database, I have actually no more problems. What is strange is that I change the version 9.2.0.6 by the version 9.2.0.5.
Do you know if there is a patch for version 9.2.0.6 which resolves the problem?
mon pote meta :
Citation:
Hi,
not sure about any patches exist for 9.2.0.6 which fix your issue, But latest supported version for 9.2 DB is 9.2.0.8.
Oracle recommend to stay up to date on latest supported patch set level.
Regards,
GiovanniR - Moderator