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.
Examples
Select the EMPNO, ENAME and SAL columns and filter out all rows with a SAL less then 3000.
begin return 'select EMPNO, ENAME, SAL from EMP where SAL < 3000';end;
Additional Information
- Type: PL/SQL Function Body returning a SQL Query
- Supported Bind Variables: Application, Page Items and System Variables
Could you please fix this? This is causing a couple of false positive alerts if we check our applications.