Skip to Main Content

SQL Developer

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!

00904. 00000 - "%s: invalid identifier" with *very* simple query

3262662Mar 28 2017 — edited Mar 28 2017

Sorry for the *noob* question, but I am new to SQL developer, having come over form the Hyperion EPM space.

I am trying to do a very simple query of one of the Hyperion Planning tables and getting the error stated above, using SQL Developer 3.2.

SELECT *

FROM HSP_AUDIT_RECORDS

WHERE USER_NAME = XXXXXXX

This table is populated, I can filter the columns of the table using the same criteria (specific user name, for example), but no matter what I try, I keep getting the ORA-00904 when I query the table.

For what it is worth, I have tried multiple columns and multiple searches for each column.  I have also tried quotes around the user name with no luck.

Thoughts?

Ed

This post has been answered by Gary Graham-Oracle on Mar 28 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 25 2017
Added on Mar 28 2017
4 comments
28,762 views