SQL & PL/SQL

Hi all,

i receive error ORA-01801: date format is too long for internal buffer when i try to run pl/sql procedure in sqlplus. But if i seperately run select statements for the same procedure in TOAD results are there. Is there a bad value inside the column table or there are problems with dates.

Regarding dates i have only this condition:

.
.
AND (TO_DATE (t.ferja || LPAD (t.urca, 6, '0'), 'YYYYMMDDHH24MISS') >=
TO_DATE (20110628130000, 'YYYYMMDDHH24MISS')
OR TO_DATE (c.ferja || LPAD (fec.urca, 6, '0'), 'YYYYMMDDHH24MISS') >=
TO_DATE (20110628130000, 'YYYYMMDDHH24MISS'))
/* Expiry date >= current date */
AND NVL (TO_NUMBER (SUBSTR (TO_CHAR (t.vigea), 3, 4)), 0) >=
TO_CHAR (SYSDATE, 'YYMM');

Any help would be appreciated.Thank you.

Regards,

Robert