ORA-00972 identifier is too long

[pokaragat]

We have this field in our database:

CONFIGURATION_FROM_DATE

Another table is using this field as a foreign key. So, the navigation fields are generated with this name:

PARENT_CONFIGURATION_FROM_DATE.

When loading the refences to the to that table, we got the ORA-00972.

We looked at the DBMonitor and here's part of the statement where error occured:

SELECT ....
"Join2".PARENT_CONFIGURATION_FROM_DATE1 AS PARENT_CONFIGURATION_FROM_DATE
FROM.....

If you notice, PARENT_CONFIGURATION_FROM_DATE1 is beyond 30 characters which oracle does not like.

Renaming the column name is a stretch since this is an existing application and lots of fields are close to this length.

Any solution? Please help!

[AndreyR]

We are investigating this problem.
As a temporary solution, if you do not want to change the column name, try to create a view
with the shorter column name and work with it instead of working with table.

[DanW]

I'm getting this error as well, The problem I am having is when the driver translates the SQL and creates aliases for the fields, the alias can be more than 30 Char long. Any ETA on when this might be fixed? Thanks,
-DanW

PS, I Posted this issue to Ideablade originally, and they directed me to you guys, at which point I found the existing post here. Here's the link to the Ideablade post (which contains the problem query):

http://www.ideablade.com/forum/forum_po ... =5107#5107

[AndreyR]

We plan to fix this issue in the next build of dotConnect for Oracle.

[AndreyR]

The issue is fixed, look forward to the next build.