Re: ORA-01830 On Delete but not on Select?

Anurag,

unfortunateley there are no triggers defined for this table.

Even a

create table testlog as select * from mflogbook; commit;
DELETE FROM testlog WHERE TO_DATE(TRIM(DATETIME), 'DD.MM.YYYY HH24:MI:SS')+30 < TO_DATE('22.03.2007', 'DD.MM.YYYY');

was yielding the same ORA-01830.

Do you have another idea?

Thanks

Jens Mohrmann

"Anurag Varma" <avoracle_at_gmail.com> schrieb im Newsbeitrag news:1174599402.805030.203220_at_o5g2000hsb.googlegroups.com...

>