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.