Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Table with references constraints gives internal error
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,
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>`
![]() |
![]() |