Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

ORA-00984: column not allowed here

Posted on 2007-10-20
2
Medium Priority
?
3,079 Views
Last Modified: 2013-12-19
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
0
Comment
Question by:freqout
  • 2
2 Comments
 
LVL 7

Accepted Solution

by:
jax79sg earned 2000 total points
ID: 20116830
try this instead

insert into messages values (100, 'fakeuser', 'freqout', sysdate, 123)
0
 
LVL 7

Expert Comment

by:jax79sg
ID: 20116833
Note the single quotes.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question