ORA-00984 column not allowed here

Question: What is the cause of the “ORA-00984 column not allowed here” error? How do I resolve this?

    • INSERT INTO accounts (account_id, account_name)
    • VALUES (5467, vitalsofttech);
    • ORA-00984 column not allowed here

Reason: When this message is returned from a DML statement it is usually due to the a text value not within the single quotes. Oracle interprets the value as a column name.

Solution: Ensure that the text values are bound in single quotes.

    • INSERT INTO accounts (account_id, account_name)
    • VALUES (5467, ‘vitalsofttech’);
    • 1 row inserted.

Issue resolved!

Related OraTips

Learn about Deprecated Database Parameters in Oracle 12c – When upgrading to Oracle 12c it’s good to be familiar with these parameters. Read more here.

Solving RMAN-06059: Errror identifying file – When using RMAN to backup archivelog files, an error “RMAN-06059: Errror identifying file ” is returned. Previously the backups have been running successfully prior to this.

Other Articles

Oracle 12c Database: What is Oracle 12c? There has been a lot of buzz recently about Oracle 12c. Everyone in any way related to Oracle technologies, really want to know what Oracle 12c is and why it is important. Well, simply put it is the next generation naming convention for all Oracle products. Learn more about it here.

Oracle 12c Database: New Features The Oracle 12c Database has the most new features ever released with any version of any database. As you might have guessed from it’s name, the new version is more focused on Cloud Computing.

 

Note: This Oracle documentation was created for reference for use by Vitalsofttech DBA’s. If you have any questions please post by clicking on the ASK A QUESTION link above.

Leave a Reply

Your email address will not be published.