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!

apex23.1 ORA-01403 on apex export -applicationid 1234 --expType READABLE_YAML

zakiHMay 18 2023

error trying to export readable yaml from apex23.1

apex export -applicationid 1234 --expType READABLE_YAML

ORA-01403: no data found
ORA-06512: at "APEX_230100.WWV_FLOW_EXPORT_API", line 143
ORA-06512: at "APEX_230100.WWV_META_META_DATA", line 2282
ORA-06512: at "APEX_230100.WWV_META_META_DATA", line 2269
ORA-06512: at "APEX_230100.WWV_FLOW_EXPORT_INT", line 1151
ORA-06512: at "APEX_230100.WWV_FLOW_EXPORT_INT", line 1248
ORA-06512: at "APEX_230100.WWV_FLOW_EXPORT_API", line 81
ORA-06512: at line 3

ORA-01403: no data found
ORA-06512: at "APEX_230100.WWV_FLOW_EXPORT_API", line 143
ORA-06512: at "APEX_230100.WWV_META_META_DATA", line 2282
ORA-06512: at "APEX_230100.WWV_META_META_DATA", line 2269
ORA-06512: at "APEX_230100.WWV_FLOW_EXPORT_INT", line 1151
ORA-06512: at "APEX_230100.WWV_FLOW_EXPORT_INT", line 1248
ORA-06512: at "APEX_230100.WWV_FLOW_EXPORT_API", line 81
ORA-06512: at line 3

retrying the command without a commit or rollback got

ORA-01453: SET TRANSACTION must be first statement of transaction
ORA-06512: at "APEX_230100.WWV_FLOW_EXPORT_API", line 143
ORA-06512: at "APEX_230100.WWV_FLOW_EXPORT_API", line 53
ORA-06512: at line 3

ORA-01453: SET TRANSACTION must be first statement of transaction
ORA-06512: at "APEX_230100.WWV_FLOW_EXPORT_API", line 143
ORA-06512: at "APEX_230100.WWV_FLOW_EXPORT_API", line 53
ORA-06512: at line 3

Added on May 18 2023

15 comments

800 views