Hi! After updating to APEX 18.2 there are two problems. First is ORA-00918: column ambiguously defined. When in Page Designer you use "PL/SQL Function Body returning SQL Query" as a source and there are columns with the same name there is ORA-00918. For example:
declare
l_sql varchar2(2000);
begin
l\_sql := 'Select rd.description,
rdt.description
....
Validation is successful as it was In Apex 5, but when we try to look at a result in a browser "ORA-00918: column ambiguously defined" appears.
The second problem is when we use "PL/SQL Function Body returning SQL Query" (no matter what's inside) as a source and trying to do a validation on "Is Valid SQL or PL/SQL Code" there is always an error:
Compilation error - ORA-06550: line 36, column 3:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
; <an identifier> <a double-quoted delimited-identifier>
The symbol ";" was substituted for "end-of-file" to continue.
Are there any solutions? Thank you!
