Appreciate for Your answer. Would You clarify, have You checked page with Your dynamic example in APEX Advisor? On my APEX 22.2.0 even code exactly from APEX Help fails in that warning. Yes, code works, but Advisor says "Code Category Error Message Compilation error - ORA-06550" etc.
Sasha Gomanuke
Software developer
Jon, i do appreciate for clear view on that great APEX 222 feature! But would You clarify APEX Advisor of that? I mean that Advisor don't like any new Dynamic region...
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 33, column 3: PLS-00372: In a procedure, RETURN statement cannot contain an expression