Insert Query not able run on sql developer. Showing error ORA-00600

903 views Asked by At

I am new to plsql and oracle database. I just created a table

CREATE TABLE contacts
( con_id number(4) PRIMARY key,
  company_name varchar2(30) NOT NULL,
  e_mail varchar2(30),
  last_date date default systimestamp,
  con_cnt number(3) check(con_cnt > 0)
);

it is successfully created but insert query

insert into CONTACTS(con_id, COMPANY_NAME, e_mail, last_date, con_cnt)
 VALUES (01,'hrSol','[email protected]','12-12-12',12);

shows following error:

SQL Error: ORA-00600: internal error code, arguments: [12811], [284560], [], [], [], [], [], [], [], [], [], []
00600. 00000 -  "internal error code, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s]"
*Cause:    This is the generic internal error number for Oracle program
           exceptions. It indicates that a process has encountered a low-level,
           unexpected condition. The first argument is the internal message
           number. This argument and the database version number are critical in
           identifying the root cause and the potential impact to your system.
Error starting at line : 75 in command -
update CONTACTS
SET e_mail = '[email protected]'
WHERE con_id = 01
Error at Command Line : 75 Column : 1
Error report -
SQL Error: Closed Connection

I tried inserting values in other tables and it works fine. Just this table is giving the problem.

0

There are 0 answers