10g to 11g migration.

[vanikanc]

Hi, We just migrated from Oracle 10g to 11g. And one the report started failing after this. One of the reports is not working with the error - Oracle Error: ORA-00918: column ambiguously defined in 11g. It is failing at this line, '"'||mo_oaa.NAMEX||mo_oaa.NAMEX2||'"' "NAME",

[Lost User]

Probably the quotes. Remove those and try your query again.

Bastard Programmer from Hell :suss: if you can't read my code, try converting it here[^]