[SOLVED] Error when searching: identifier is too long
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
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.
