I am getting error message when I tried to load data into oracle table. is there a way to fix in SAS or needs to be fixed in Oracle?
log:
WARNING: The following ERROR/WARNING is being ignored (due to ERRLIMIT option):
ERROR: ORACLE execute error: ORA-01438: value larger than specified precision allowed
for this column.
The number of ERROR/WARNINGs occurred so far: 1.
WARNING: The following ERROR/WARNING is being ignored (due to ERRLIMIT option):
ERROR: ORACLE execute error: ORA-01426: numeric overflow.
The number of ERROR/WARNINGs occurred so far: 285.
WARNING: The following ERROR/WARNING is being ignored (due to ERRLIMIT option):
ERROR: ORACLE execute error: ORA-01438: value larger than specified precision allowed
for this column.
The number of ERROR/WARNINGs occurred so far: 286.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.