My Oracle Support Banner

While retrieving data from an interactive report, the user gets ORA-14551 (Doc ID 2730597.1)

Last updated on FEBRUARY 18, 2021

Applies to:

Oracle Application Express (APEX) - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

While retrieving data from an interactive report, the user gets ORA-14551

apex_ir.get_report()

ORA-14551: Cannot perform DML operation within a query

ORA-06512: in "APEX_190200.WWV_FLOW_PREFERENCES", Zeile 73
ORA-06512: in "APEX_190200.WWV_FLOW_IR_RENDER", Zeile 1014
ORA-06512: in "APEX_190200.WWV_FLOW_IR_RENDER", Zeile 2147
ORA-06512: in "APEX_190200.WWV_FLOW_IR_API", Zeile 230

apex_region.open_query_context()

ORA-14551: Cannot perform DML operation within a query

ORA-06512: in "APEX_190200.WWV_FLOW_PREFERENCES", Zeile 73
ORA-06512: in "APEX_190200.WWV_FLOW_IR_RENDER", Zeile 1014
ORA-06512: in "APEX_190200.WWV_FLOW_IR_RENDER", Zeile 2147
ORA-06512: in "APEX_190200.WWV_FLOW_IR", Zeile 6410
ORA-06512: in "APEX_190200.WWV_FLOW_REGION", Zeile 707
ORA-06512: in "APEX_190200.WWV_FLOW_REGION_API", Zeile 80

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.