Home » SQL & PL/SQL » SQL & PL/SQL » Get "ORA -00984 colunm not allowed" using Access 2000 to insert records in Oracle table read from a
Get "ORA -00984 colunm not allowed" using Access 2000 to insert records in Oracle table read from a [message #473] Thu, 14 February 2002 13:13 Go to next message
Mary Ellen Smith
Messages: 1
Registered: February 2002
Junior Member
I am using Access 2000 as a front end to Oracle. I need to insert records into the Oracle tables from a text file. I keep getting the error message ORA-000984 "Colunm not allowed here" when I thy to execute the insert statement.
Here is my insert statement:cmd.CommandText = "Insert INTO Fac_Pat_DptCharges_Tbl ( FACILITY_ID, ADMISSION_NUMBER, FACILITY_DEPARTMENT, PS_GL_DEPT_NUM, PS_GL_SATELLITE_NUM, SERVICE_DATE, POST_DATE, TOTAL_UNITS, TOTAL_CHARGES, TOTAL_COST )" _
& " VALUES('Fac', AdmitNumber, 'FacDept', 'PSGLDept', 'PSGLSatNo', TO_DATE('ServDate', 'MM/DD/YYYY'), TO_DATE('postDATE', 'MM/DD/YYYY'), TotalUnits, TotalCharges, TotalCost)" Any suggestions?

Report message to a moderator

Re: Get "ORA -00984 colunm not allowed" using Access 2000 to insert records in Oracle table read fr [message #483 is a reply to message #473] Thu, 14 February 2002 23:49 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
ORA-00984 column not allowed here
------------------------------------------
Cause: A column name was used in an expression where it is not permitted, such as in the VALUES clause of an INSERT statement.
Action: Check the syntax of the statement and use column names only where appropriate.

Report message to a moderator

Re: Get "ORA -00984 colunm not allowed" using Access 2000 to insert records in Oracle table read fr [message #3501 is a reply to message #483] Mon, 30 September 2002 17:46 Go to previous messageGo to next message
Chris
Messages: 128
Registered: November 1998
Senior Member
I had a similar problem.Are you using single quotes on your varchar values ?

Report message to a moderator

Re: Get "ORA -00984 colunm not allowed" using Access 2000 to insert records in Oracle table read fr [message #3581 is a reply to message #483] Mon, 07 October 2002 05:29 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
There is some mismatch in values given to the columns.

For example if the Column type is Number and you insert a string or column type is date and you insert a string and so on... this error occur.

Check your data what you are inserting to a table and column type.

Report message to a moderator

Previous Topic: unsure of best practice
Next Topic: Looking For Solution
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 05 18:03:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.