APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-22816: unsupported feature with RETURNING clause

Phil Cannata-OracleMay 14 2019 — edited May 15 2019

I have an "update instead of trigger" on one of my tables and when an APEX form tries to do an update, I get the following error:

ORA-22816: unsupported feature with RETURNING clause

Is there any way to have APEX do an update without a returning clause?

user9540031

The documentation for the OPTIMIZER_ADAPTIVE_STATISTICS parameter (remark: modifiable in a PDB) states:
OPTIMIZER_ADAPTIVE_STATISTICS does not control the creation of SQL plan directives. SQL plan directives will be created even if this parameter is false, but they will not be used to refine SQL execution plans with dynamic sampling.
Therefore, if the AUTO_STAT_EXTENSIONS statistics preference is set to ON, it would be normal that statistics extensions be created.
Related blog articles by Frank Pachot and Christian Antognini:
https://blog.dbi-services.com/matching-sql-plan-directives-and-queries-using-it/
https://blog.dbi-services.com/dba_sql_plan_directive-last_used/
https://antognini.ch/2017/11/spd-state-does-not-change-if-adaptive-statistics-are-disabled/
Remarks:
Sadly, the +metrics format option (so far undocumented) seems to work only in dbms_xplan.display; it does nothing apparently in calls to dbms_xplan.display_cursor—I didn't try, but I wouldn't expect it to do anything in calls to dbms_xplan.display_awr either.
Christian Antognini's post includes a test script; I ran it on a 19.5 test DB, which behaved exactly as described.

1 - 1

Added on May 14 2019

#apex-discussions

4 comments

4,416 views

APEX

ORA-22816: unsupported feature with RETURNING clause

Comments

Post Details