ORA-00972: identifier is too long ERROR

ORA-00972: identifier is too long ERROR

  

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.


Are you using an Advanced Query?

Can you show us the SQL statement?

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.

Solution

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-