Hi,
I try to use APEX_DATA_PARSER.PARSE to read a XLS BLOB File. Unfortunatly one of it's Date Columns contain values like 42522, in other words not correct Date formats. Therefore it correctly brings back the error message ORA-01841: (full) year must be between -4713 and +9999, but I want to avoid this error and consider this column as a VARCHAR2 instead!?
Is there a solution or workaround for it?
cheers,
Bernhard