Invalid identifier error

Question

I have this simple table:

CREATE TABLE foo
(
 storeName varchar(50),
 keyName varchar(50),
 docname varchar(512),
 config clob,
 CONSTRAINT foo_pk PRIMARY KEY(storeName, keyName)
)

And this select statement:

SELECT config ,docname
FROM foo 
WHERE storeName = 'SolutionFramework' 
AND keyName = 'Solutions'

And this is the error I get: (42000/904) ORA-00904: "KEYNAME": invalid identifier

Can anyone help me with this?

Are you sure you created the column as keyName and not as "keyName"? The latter preserves case in the name and forces you to refer to it in a case-sensitive manner, i.e. as "keyName". — Klas Lindbäck
and here is a sqlfiddle demo for @KlasLindbäck suggestion sqlfiddle.com/#!4/0cb76/1 — A.B.Cade

igr igr · Accepted Answer · 2013-01-21T11:49:07

0

votes

Remove quotes around keyName in CREATE TABLE command.

Invalid identifier error

2 Answers