Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid Identifier error

561112Oct 17 2007 — edited Oct 17 2007
I've been looking all over trying to figure out why I'm getting this error and can't figure it out. I'm just trying to make a table to keep track of unique hits on a page so the table looks like this with a select * from HIT_COUNTER:

url counter id
---------------------------------- ---------- -----
test.htm 0 1
http://localhost:8040/test.jsp 0 2

I am having trouble updating my counter field. When I try
UPDATE HIT_COUNTER SET counter = 1 WHERE url = 'test.jsp'
I get
ORA-00904: "URL": invalid identifier

It's obvious that the "url" field exists, so why do I get this error?

Thanks for any help

*edit, I'm having trouble getting the formatting to look correct in the select results, but I think you can get the idea
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 14 2007
Added on Oct 17 2007
8 comments
674 views