ORA-00972 identifier is too long

ORA-00972 identifier is too long

Postby pokaragat » Wed 19 Nov 2008 21:28

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!
pokaragat
 
Posts: 23
Joined: Mon 15 Sep 2008 21:09

Postby AndreyR » Thu 20 Nov 2008 10:52

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.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Not Fixed Yet?

Postby DanW » Tue 04 Aug 2009 18:29

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
DanW
 
Posts: 1
Joined: Tue 04 Aug 2009 18:16

Postby AndreyR » Fri 07 Aug 2009 08:51

We plan to fix this issue in the next build of dotConnect for Oracle.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby AndreyR » Thu 17 Sep 2009 08:44

The issue is fixed, look forward to the next build.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for Oracle