I love PL/SQL but there are some missing features that very annoying:
- Result cache is very nice but restrictions like authid CURRENT_USER (CLOB, BLOB) should only make the cache algorithm not to be applied but not issuing an compilation error (giving only a compilation pls warning) so the code could be prepared for future implementation of the result cache without those restrictions.
The use of VPDs should be 100% transparent with Result cache, i.e. using VPD should not imply a change in the code to work correctly!
- Conditional compilation is nice but cannot check if the oracle version is 126.96.36.199 (or above) only can check 11.2 and oracle implemented new features (like UTL_SMTP using TLS/SSL connection) in that new “patched” version. (here the problem is the missing global constant for anything “below” the minor number or maybe the numbering of that version)
- Automatic detection of "pure" user-defined PL/SQL functions for parallelism (in parallel queries) for functions in packages (like Oracle does for stand-alone (not in package) functions).
BTW: Editions look great but we encounter a bug that “corrupted” the catalog and so the DBAs are not confident to continue to use it for now.