The Oracle APEX team received an report and evidenced a BUG no 36847892 named "PACKAGE COMPILE ERROR FROM SUPPORTING OBJECT AND SQL WORKSHOP IF TABLE TYPE DECLARED"
The problem is that You gen an error when You try to compile the package which contains a table type definition.
For example:
Hopefully, this BUG should be fixed soon.
But meanwhile there is an override for this BUG.
Simply create another type of type RECORD at the beginning of the code and it should compile without an error. No need to use this type later in the code... just let it sit there for the time being 😸
For example like this:
No comments:
Post a Comment