Apex Advisor fails on "PL/SQL Function Body returning SQL Query" - any version
If you define a source based on type: Function Body returning SQL Query
and let the apex advisor check for PL/SQL errors - it aways fails on this:
Error output of Advisor:
Attribute | Region Source (Identifies the source of the region, reference Region Source Type) |
|---|---|
Check | Is Valid SQL or PL/SQL Code |
Category | Error |
Message | Compilation error - ORA-06550: line 3, 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. |
Help Text / Hint:
PL/SQL Function Body returning SQL Query
Enter a PL/SQL function body that returns an SQL Query for this component.
0