ORA - 00972: identifier is too long

Help Studio
1

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.

Regards
Suresh Ghadai

2

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

3

@Suresh_Ghadai

Check below for your reference

Hope this may help you

Thanks

4

Can we see the variable and the value been passed

Does that include any single quotes in the expression

Cheers @Suresh_Ghadai