This topic is locked
[SOLVED]

 Error when searching: identifier is too long

12/12/2006 7:17:15 PM
ASPRunnerPro General questions
J
jbruxe author

Hello,
Has anyone run into an error like this before?
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Oracle][ODBC][Ora]ORA-00972: identifier is too long
Searching has not been an issue in the past, but now it is.
Any advice would be greatly appreciated.
Josh

Sergey Kornilov admin 12/12/2006

Josh,
it appears that one of identifiers in search query is longer than 30 characters.
You can post your query here for investigation.
Oracle/PLSQL: ORA-00972 Error
--------------------------------------------------------------------------------
Error: ORA-00972: identifier is too long
Cause: You tried to reference a table, cluster, view, index, synonym, tablespace, or username with a value that was longer than 30 characters.
Action: The options to resolve this Oracle error are:
Names for tables, clusters, views, indexes, synonyms, tablespaces, and usernames must be 30 characters or less. You must shorten the name to no more than 30 characters for these objects.