January 10th, 2005, 12:59 PM
|
|
Registered User
|
|
Join Date: Jan 2004
Posts: 7
Time spent in forums: 45 m 5 sec
Reputation Power: 0
|
|
|
column not allowed here Exception
Hi,
I get the following exception
ORA-00984: column not allowed here
when i execute the following query
insert into esclate_tasks values (152,1,'1/10/2005 12:39:50','undefined','undefined','New','undefined',undefined,'undefined','20')
This is on a oracle table.
The schema looks like
CREATE TABLE esclate_tasks (
Task_id Number(18, 0) NOT NULL ,
SEQ Number(18, 0) NOT NULL ,
escl_dt Date NOT NULL ,
escl_uca_msg varchar (80) NULL ,
escl_sub_process varchar (50) NULL ,
status char (10) NULL ,
escl_status varchar (2) NULL ,
escl_custom_status_id Number(18, 0) NULL ,
escl_category varchar (80) NULL ,
escl_priority_id Number(18, 0) NULL
)
Thanks.
Last edited by vi1972 : January 10th, 2005 at 01:01 PM.
Reason: Adding more data
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
