external table -- Issues with specific data
I am receiving the following error, when I am trying to fetch the data with the external table. I have tried with the sqlloader for the same and it worked without any issues. Just to be noted, It is working fine, if I exclude the year and month columns from the external table. For some reason, it is having issues with year and month data.
Your inputs on this issue greatly appreciated.
SQL> select count(*) from XTERN_YTD_PREMIUM_TRANS;
select count(*) from XTERN_YTD_PREMIUM_TRANS
*
ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error