Home/ Questions/Q 4522
In Process

vinish.ai Latest Questions

  • 0
  • 0
Asked: 2021-01-14T15:41:52+00:00

adjust error column in data load results page in Oracle Apex

  • 0
  • 0

Hello sir, I am very grateful for your posts, it helps me a lot.
I have one question:
In my application, I use the data load wizard for uploading data. I want to adjust the content in the error column of the data load result page in the data load wizard progress so that when the user sees the error, they will understand what it is. For example, when reporting a constraint error, if the default, apex will display “ORA-00001: unique constraint (…) violated” I want to replace it with my message is”Duplicated data, check again.” and other errors.
If it is the default, we can not adjust it so do you have any solution for this problem?

THANKS, A LOT.

dataloadresulterrororacle apex
Share
Leave an answer

Leave an answer

Browse

2 Answers

  1. In Oracle Apex, upload data wizard logs error information in the collection and creates the report using the collection.

    So it is better to modify the query to replace the error column usually (c048) using the case statement. Below is an example:

    In the “Data Load Results” page, modify the failed records region query as following:

    select n001 as row_num,
wwv_flow_lang.system_message( 'DATA_LOAD.' || c049 ) as action,
case when substr(c048, 1, 14) = '-1 : ORA-00001' then
'Duplicate row'
else 
c048
end error,
c001, c002, c003,
c004, c005, c006,
c007, c008, c009,
c010, c011, c012,
c013, c014, c015,
c016, c017, c018,
c019, c020, c021,
c022, c023, c024,
c025, c026, c027,
c028, c029, c030,
c031, c032, c033,
c034, c035, c036,
c037, c038, c039,
c040, c041, c042,
c043, c044, c045
from apex_collections
where collection_name = 'LOAD_CONTENT'
and c047 in ('FAILED') 
order by seq_id

    In the above query, you can see, I am checking the first 14 characters of the C048 column, that if the value is ‘-1 : ORA-00001’, then replacing the error message with Duplicate Row. Similarly, you can replace any other errors too.

    The following is the output now:

    Oracle Apex: Data upload error.