This is a referential integrity constraint violation notice, Jordi. There's
a least one entry, in another table, referencing the entry in "paises"
you're trying to delete. To accomplish this, you must either delete this
other entry (child record) first or disable the constraint.
--
Francisco Carlos Piragibe de Almeida
consultant
ORACLE products and WEB applications
Jordi Bellver <jbellver_at_ipgrup.com> escreveu no artigo
<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
