ORA-00984: column not allowed here

Why am I getting this error?

SQL> insert into messages values ("100", "fakeuser", "freqout", sysdate, "blah");
insert into messages values ("100", "fakeuser", "freqout", sysdate, "blah")
                                                                    *
ERROR at line 1:
ORA-00984: column not allowed here

SQL> desc messages
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------

 MESSAGEID                                          NUMBER(38)
 MSGFROM                                            VARCHAR2(50)
 MSGTO                                              VARCHAR2(50)
 SENT                                               DATE
 MESSAGE                                            LONG
freqoutAsked:
Who is Participating?
 
jax79sgCommented:
try this instead

insert into messages values (100, 'fakeuser', 'freqout', sysdate, 123)
0
 
jax79sgCommented:
Note the single quotes.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.