plsql - Oracle PSQL getting reason of error in a with as expression

Question

I have a more thousand lines "with as" sql. When I try to run it I've got a message: "Expression must have same datatype as corresponding expression", but I cannot get any info where is it and which field is not the same type. In a normal sql I can get it, but in with as I cannot. Yes I know "with as" is not the best practice, but I have to port an old sql to a new environment.

Is there any trick to get where is it?

question from:https://stackoverflow.com/questions/66048247/oracle-psql-getting-reason-of-error-in-a-with-as-expression

Answer 1

Waitting for answers