Error handling while loading the data in Oracle Apex 22.1.4

Annamalai V

I am using Oracle Apex 22.1.4 version. My requirement is to capture the error records and store them somewhere else while loading the data from xlsx/csv file.

If it's stored in some error log tables/ somewhere else internally, I can create a report on top of that table and display them to the users.

I saw one of the blogs from Oracle and I came to know that it was a very simple and easy method of capturing error records and storing them in Error tables in Oracle Apex 19.1

https://blogs.oracle.com/apex/post/quick-and-easy-data-loading-with-apex-191

Is there any similar way of capturing error data and storing them in Oracle Apex 22.1?

If yes, please give me suggestions.

Thanks,

Annamalai V.

jariola

If you use out of box data load feature, there option define error table or collection in data load definition.

https://docs.oracle.com/en/database/oracle/apex/22.1/htmdb/creating-applications-with-data-loading-capability.html#GUID-9475D0A8-CBF2-491B-A09A-EACE5864AEA6

jariola

I don't know is there better way than create function that validates all those date column values in error table and returns e.g. column name that don't pass validation.

jariola

If you use out of box data load feature, there option define error table or collection in data load definition.

https://docs.oracle.com/en/database/oracle/apex/22.1/htmdb/creating-applications-with-data-loading-capability.html#GUID-9475D0A8-CBF2-491B-A09A-EACE5864AEA6

Annamalai V

Thank you. This helps me a lot.

I have one more quick question. I have implemented Log into Error Log method for Error Handling.

The error table contains the details of the error records. One of the errors is ORA-01843: not a valid month.

There are 7 date columns in the target table. I want to know for which date column, the error is present in it.

Is there any way to find that?

Thanks,

Annamalai V.

jariola

I don't know is there better way than create function that validates all those date column values in error table and returns e.g. column name that don't pass validation.

Annamalai V

Okay, I will create a function for doing that validation.

Once again, thanks a lot for clarifying me.