I don't have Oracle access here, but you may be able to investigate the metadata Oracle table all_tab_columns where table_name = your table. That will show the column types.
Alternatively, proc contents on the Oracle view or do a subset extract:
proc sql outobs=10000;
create table x
from connection to oracle(
etc etc
); (or from view of Oracle table, of course)
quit;
then do a contents on that.
... View more
