Re: ON DELETE CASCADE PROBLEM

Huh?
SQL> insert into pelates values (1,'row 1 col 2', 'row 1 col 3')   2 /

1 row created.

SQL> insert into pelates values (2,'row 2 col 2', 'row 2 col 3')   2 /

1 row created.

SQL> insert into aytokinhta values (1, 'row 1 col 2', 'row 1 col 3', 'col4', 1 )
  2 /

1 row created.

SQL> insert into aytokinhta values (2, 'row 2 col 2', 'row 2 col 3', 'col4', 2 )
  2 /

1 row created.

SQL> select * from pelates
  2 /

KODIKOS_PELATH ONOMATEPONYMO                  POLH
-------------- ------------------------------ ---------------
             2 row 2 col 2                    row 2 col 3
             1 row 1 col 2                    row 1 col 3

SQL> select * from aytokinhta
  2 /

KODIKOS_AYTOKINHTOY KATASKEYASTHS MONTELO PINAKID

------------------- -------------------- -------------------- -------

                  2 row 2 col 2          row 2 col 3          col4
                2

                  1 row 1 col 2          row 1 col 3          col4
                1

SQL> delete from pelates where kodikos_pelath = 1   2 /

1 row deleted.

SQL> select * from pelates
  2 /

KODIKOS_PELATH ONOMATEPONYMO                  POLH
-------------- ------------------------------ ---------------
             2 row 2 col 2                    row 2 col 3

SQL> select * from aytokinhta
  2 /

KODIKOS_AYTOKINHTOY KATASKEYASTHS MONTELO PINAKID

------------------- -------------------- -------------------- -------

                  2 row 2 col 2          row 2 col 3          col4
                2

SQL> delete from pelates where kodikos_pelath = 2   2 /

1 row deleted.

SQL> select * from pelates
  2 /

no rows selected

SQL> select * from aytokinhta
  2 /

no rows selected

"kotsos" <fakidomitis_at_yahoo.gr> wrote in message news:bs5114$630$1_at_usenet.otenet.gr...
> Hi ...
>
> I'm a newbie in Oracle 8i and I have the following problem:
>
> I created two tables as follows:
> CREATE TABLE pelates
>
> (kodikos_pelath NUMBER(5,0) NOT NULL,
>
> onomateponymo VARCHAR2(30) NOT NULL,
>
> polh VARCHAR2(15) NOT NULL)
>
> /
>
> ALTER TABLE pelates
>
> ADD CONSTRAINT pk_kodikos_pelath PRIMARY KEY (kodikos_pelath)
>
> /
>
>
>
> CREATE TABLE aytokinhta
>
> (kodikos_aytokinhtoy NUMBER(5,0) NOT NULL,
>
> kataskeyasths VARCHAR2(20),
>
> montelo VARCHAR2(20),
>
> pinakida VARCHAR2(7) NOT NULL,
>
> kodikos_idiokthth NUMBER(5,0) NOT NULL)
>
> /
>
> ALTER TABLE aytokinhta
>
> ADD CONSTRAINT pk_kodikos_aytokinhtoy PRIMARY KEY (kodikos_aytokinhtoy)
>
> /
>
> ALTER TABLE aytokinhta
>
> ADD CONSTRAINT fk_to_pelates FOREIGN KEY (kodikos_idiokthth)
>
> REFERENCES pelates (kodikos_pelath)on delete cascade
>
> /
>
>
>
>
>
> ... and I filled them with values
>
> But whenever I try to delete some rows from pelates, then a message
appears
> concerning the foreign key constraint (of table aytokinhta) although I
> declared the "on delete cascade" option....
>
>
>
> Any ideas?
>
>
>
>
>
> Thank you...
>
>
>
>
>
>
>
>
Received on Mon Dec 22 2003 - 18:11:36 CET