ORA - 00972: identifier is too long

Hi Team,

I am getting the below error message while reading the query from an excel and assigning that variable to run the Execute Query.

Error Message : " ORA - 00972: identifier is too long"

It is working if i am giving the query directly in the execute Query.

Please help me resolving the above error.

Suresh Ghadai

Hi @Suresh_Ghadai ,

Could you try following the instructions detailed in this post and see if that works out for you?

Kind Regards,
Ashwin A.K


Check below for your reference

Hope this may help you


Can we see the variable and the value been passed

Does that include any single quotes in the expression

Cheers @Suresh_Ghadai