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

Home -> Community -> Mailing Lists -> Oracle-L -> Table with references constraints gives internal error

Table with references constraints gives internal error

From: Alex Sirota <adapple_at_APPLE.COM>
Date: Sun, 19 Mar 1995 15:57:09 -0500
Message-Id: <9503192341.AA01251@alice.jcc.com>


Hello all. Please respond directly to my email in the header if you have an idea for this one.

Oracle7.0.12.2.0 on A/UX

I created a table with several references column constraints. The referencing columns are ALL primary keys in their respective tables.

When I try to do an insert on this table I get an

ORA-00600 internal error code, arguments: [12832], [], [], [], [], []

The DDL for the table in question is

create table applic_org_map
( org_num integer not null constraint blah1 references org_num_defs (org_num),

applic_num integer not null,
applic_type char(1) constraint blah2 references applic_type_defs (applic_type),
applic_location char(2) constraint blah3 references applic_loc_defs (applic_loc)
date_entered default sysdate,
constraint unique_cons unique (applic_num, applic_type, applic_location) using index tablespace index_ts);

org_num.defs.org_num, applic_type_defs.applic_type and applic_loc_defs.applic_loc are all defined as primary keys. The DDL for the applic_org_map table worked just fine. But inserts argh. Is this a bug?

`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`
`,`,`Alex Sirota,`,`,`,`,`,`,Genius is an African that dreams of snow.`,`,`
`,`,`adapple_at_apple.com`,`,`,`,`,`,`,`,`,`,`,``,`,`-Vladimir Nabokov,`,`,`,`
`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`

`,<URL:http://atlantis.austin.apple.com/people.pages/adapple/adapple.html>`

`,`,`,`,`,`,Apple Web Server: <URL:http://www.info.apple.com/>`,`,`,`,`,`,`
`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`,`
Received on Sun Mar 19 1995 - 18:41:39 CST

Original text of this message

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