You can check up on the default Oracle data type translations here: https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.5/acreldb/p06jk0u30uhuj5n18fqw9sxr25lk.htm
How are you connecting to Oracle - using a LIBNAME statement or by some other method?
I'm afraid you will probably need to run some tests to identify which columns are causing the errors. You could try inserting a subset of the columns to isolate the problematic ones.
... View more