BUG.
Fixed in 9i.
-Original Message-
Sent: Thursday, April 11, 2002 12:51 PM
To: Multiple recipients of list ORACLE-L
Hi everybody,
Oracle 8.1.7.2, Solaris.
What is your opinion on this? Seems, Metalink doesn't have any :(
SQL> create table test_pk(
2 id nvarchar2(20) primary key
3 );
Table created.
SQL> create table test_Fk(
2 id nvarchar2(20),
3 constraint c_test_FK foreign key(id) references test_pk(id) on delete
cascade);
Table created.
SQL> insert into test_pk values (N'1');
1 row created.
SQL> insert into test_fk values (N'1');
1 row created.
SQL> commit;
Commit complete.
SQL> delete from test_pk ;
delete from test_pk
*
ERROR at line 1:
ORA-12704: character set mismatch
TIA
Vadim Gorbounov
Oracle DBA
724 Solutions Inc.
Tel:(416)226-2900 ext 5070
Email: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vadim Gorbounov
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vadim Gorbounov
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).