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

Hello,

Do you fetch all the lines with the select ? The delete process all lines, but if you have a set pause and set lines, only the first lines are fetch, and the error may be elsewhere on the lines.

Regards.

Ps, sorry for my english, it's not my language.

"Jens Mohrmann" <jmohrmann_at_snafu.de> a écrit dans le message de news: 56hemjF296ql1U1_at_mid.uni-berlin.de...
> 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...
>>
>> Are there any triggers on that table which might be causing this?
>> Anurag
>>
>
>
Received on Fri Mar 23 2007 - 06:07:54 CDT