Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> deleting child records

deleting child records

From: Finnegan Calabro <fcalabro_at_aisvt.bfg.com>
Date: Mon, 2 Aug 1999 15:06:02 -0400
Message-ID: <7o4q0a$612$1@tribune.oar.net>


how do you modify the delete command to automatically delete all child records linked to a record you're trying to delete? i tried just a regular delete and i got an error (id is the primary key in the table program and the foreign key in another table). thanks!

SQL> delete from program where id='abcdef'; delete from program where id='abcdef'

            *
ERROR at line 1:
ORA-02292: integrity constraint (METRICS.SYS_C001436) violated - child record found Received on Mon Aug 02 1999 - 14:06:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US