ORA-00972: identifier is too long ERROR

Back to Forums

Zodi-Ann Clachar

Solved

Question

Installation

I am trying to update a record in my external oracle database, but i keep getting the error:

ORA-00972: identifier is too long. Please assist.

24 May 2018

Carla Ribeiro da Fonseca

Solution

Yikes, I remember that error from using Oracle.

In short, that error means that an identifier in your query is too big.

It could be because there's an error in the query, like maybe you forgot to enclose a string value in ', or you mistook ' for " so Oracle thinks your string value is an identifier.

The best way to figure it out is to look at the generated SQL, where the error will be easier to see.

See solution in context

24 May 2018

João Heleno

MVP

Are you using an Advanced Query?

Can you show us the SQL statement?

24 May 2018

Carla Ribeiro da Fonseca

Solution

Yikes, I remember that error from using Oracle.

In short, that error means that an identifier in your query is too big.

It could be because there's an error in the query, like maybe you forgot to enclose a string value in ', or you mistook ' for " so Oracle thinks your string value is an identifier.

The best way to figure it out is to look at the generated SQL, where the error will be easier to see.

24 May 2018

Shashi Kant Shukla

Hi Joao,

You can paste the executed sql in sqldeveloper or toad and you can identify in better way where is the problem in query.

Regards

-SK-

25 May 2018

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.

See the full guidelines