SQL Error ORA-00984: column(145) not allowed here

Asked Jun 12 '18 at 14:17

Active Jun 12 '18 at 14:22

Viewed 103 times

*I understand that this question has been asked before, but none of the other answers have solved my problem

PROBLEM: trying to insert into SQL table

here is my table --

here is my statement --

INSERT INTO IFS_APP_HOLIDAY_UI VALUES("Calendar", "Russ", "russ.wilson@gmail.com", "2018", "50", "50", "25", "DP", "0", "0", "6/12/2018", "Wilson);

here is my error --

Error starting at line : 4 in command -
INSERT INTO IFS_APP_HOLIDAY_UI VALUES("Calendar", "Russ", "russ.wilson@gmail.com", "2018", "50", "50", "25", "DP", "0", "0", "6/12/2018", "Wilsom")
Error at Command Line : 4 Column : 139
Error report -
SQL Error: ORA-00984: column not allowed here
00984. 00000 -  "column not allowed here"
*Cause:    
*Action:

edited Jun 12 '18 at 14:22

Jens

67,715
15
98
113

asked Jun 12 '18 at 14:17

Cameron

You may want to remove your personal information from the error. – Ben Watson Jun 12 '18 at 14:18
5

Shouldn't your values be escaped with single quotes `'` ? – Arnaud Jun 12 '18 at 14:20
2

Double quotes are for delimited identifiers, e.g. a column named `"Calendar"`. Use single quotes for string literals, e.g. `'Calendar'`- – jarlh Jun 12 '18 at 14:21
2

"Calendar" is interpreted as an object identifier as its double quoted. – Alex K. Jun 12 '18 at 14:21
https://docs.oracle.com/database/121/SQLRF/sql_elements003.htm#SQLRF00218 – Jun 12 '18 at 14:41

SQL Error ORA-00984: column(145) not allowed here

0 Answers0