1
Vote

ORA-00918 column ambiguously defined

description

Oracle 11g gives this error when compiling GetTrackingProfile. The problem is in the line:
order by insert_date_time desc
in the open refcursor p_tracking_profile_xml code block.
After comparing this to the SQL Server code, this should be
order by tp.insert_date_time desc

comments