receiving error ORA-00984: Column not allowed here during an insert into
Hello,
I am new to oracle (converting from sybase/ms sql server) and am running into this error from what seems to be a simple command. Seems to be failing on the JOBID_SEQ.NEXTVALUE.
insert into HC_JOB_LIST values (JOBID_SEQ.NEXTVALUE,'Production',1,sysdate,sysdate,'a311300','a311300')
I am logged in as a311300
sequence is owned by A311300
the table definition is:
create table HC_JOB_LIST
(
JOB_ID NUMBER not null,
JOB_NAME VARCHAR2(30) not null,
IS_ACTIVE CHAR(1) default 1 not null,
DATE_ENTERED DATE not null,
DATE_EDITED DATE not null,
EDIT_USERID VARCHAR2(20),
CREATE_USERID VARCHAR2(20)
)
tablespace EXAMPLE
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
I am sure I am doing somethinig very simple wrong....
thanks