Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: can't delete row !
An attempt has been made to delete a row that is referenced by a foreign
key.
It is necessary to delete or update the foreign key before changing this
row.
Let me know if you have further questions.,
Chinna
Jordi Bellver <jbellver_at_ipgrup.com> wrote in article
<3416637F.642B2073_at_ipgrup.com>...
>
>
> Buenas !
>
> When I tried to delete one entry from Table 'paises' i get the
> error:
>
>
> ------------------------------------------------------------
> PL/SQL> delete from paises where id_pais='TODOS';
> ERROR 0 at line 1, column 0
> Unhandled exception ORA-02292: restricción de integridad
> (WOUSR.SYS_C001148)
> violada - registro hijo encontrado
>
> [integrity restriction violated . son register found]
>
> which was raised in a statement starting at line 1
> PDE-PXC002 Program unit execution aborted due to unhandled exception
> (2292).
> PDE-PUP001 ORA-02292: restricción de integridad (WOUSR.SYS_C001148)
> violada - registro hijo encontrado
> ------------------------------------------------------------
>
> I don't know what this means, or what to do to delete this row.
>
> this row REALLY exist !
>
>
> Can you help me, please ?
>
> Thank's in advance
>
> bye
>
>
>
Received on Tue Sep 16 1997 - 00:00:00 CDT