BookmarkSubscribeRSS Feed
sasuser1031
Calcite | Level 5

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.

1 REPLY 1

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 881 views
  • 0 likes
  • 2 in conversation