Query Generated By TopLink Causes Error "ORA-00972: identifier is too long"
Last updated on OCTOBER 25, 2016
Applies to:Oracle TopLink - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
** Check for relevance 06-AUG-2013**
TopLink returns following error:
java.sql.SQLException: ORA-00972: identifier is too long Error Code: 972
This happens when an underlying database column has a name that contains 30 characters. As TopLink adds some additional numbers when generating the alias for the columns, the maximum length of the alias exceeds 30 characters which causes an ORA-00972 error.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms