Oracle Execute Error Ora-01438
Contents |
Samples & SAS Notes Focus Areas SUPPORT License Assistance Manage My Software Account Downloads & Hot Fixes TRAINING & BOOKS Books Training Certification SAS Global Academic Program SAS OnDemand For Academics USERS GROUPS Advanced Search support.sas.com Knowledge Base Support Training & ora-01438 value larger than specified precision Books Store Support Communities Knowledge Base Products & Solutions System Requirements Install Center ora-01438 how to find column name Third-Party Software Reference Documentation Papers Samples & SAS Notes Browse by Topic Search Samples Search Usage Notes Search Installation Notes Search Problem
How To Resolve Ora-01438
Notes Focus Areas Usage Note 19214: ora-01438: value larger than specified precision allows for this column The following error may be issued whern accessing Oracle data using SAS/ACCESS to load an Oracle table using insert
Sql Error: 1438, Sqlstate: 22003
table as select * from sastable. . ERROR: ORACLE execute error: ORA-01438: value larger than specified precision allows for this column. The issue appears to be related to the fact that if a table in Oracle contains a field defined as number(2,5), Oracle will allow the table to be created without error. However, Oracle will not allow any entry into this table if the improperly defined attribute is not null (and will number precision in oracle only give an error when the attribute is attempted to be loaded). This is why the columns creating the error could not be found. To identify the error, put the dba entry test data into each column one at a time. Once you get the columns where the precision was greater than the field width, you are able to isolate the issue to just those columns. To resolve this problem, redefine the table. In this example, the proper definition for this field in Oracle is number(7,5). In Oracle the 7 = width of the field and the 5 is the number of digits to the right of the decimal point. Once the table is redefined in Oracle and in SAS, you will be able to load the table using insert table as select * from sastable. Operating System and Release InformationProduct FamilyProductSystemSAS ReleaseReportedFixed*SAS SystemSAS/ACCESS Interface to Oracle64-bit Enabled HP-UX9.1 TS1M364-bit Enabled Solaris9.1 TS1M3Linux9.1 TS1M364-bit Enabled AIX9.1 TS1M3* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed. Type:Usage NotePriority:Topic:SAS Reference ==> LIBNAME EnginesData Management ==> Data Sources ==> External Databases ==> OracleDate Modified:2008-03-05 11:45:31Date Created:2006-12-19 11:35:17 This content is presented in an iframe, which your browser does not
Samples & SAS Notes Focus Areas SUPPORT License Assistance Manage My Software Account Downloads & Hot Fixes TRAINING & BOOKS Books Training Certification
Oracle Ora-01438 Which Column
SAS Global Academic Program SAS OnDemand For Academics USERS GROUPS Advanced oracle error 1438 Search support.sas.com Knowledge Base Support Training & Books Store Support Communities Knowledge Base Products & ora-01438 identify column Solutions System Requirements Install Center Third-Party Software Reference Documentation Papers Samples & SAS Notes Browse by Topic Search Samples Search Usage Notes Search Installation Notes Search Problem http://support.sas.com/kb/19/214.html Notes Focus Areas Problem Note 37020: ERROR: "ORACLE execute error: ORA-01438: value larger than specified precision allowed for this column" When running SAS Merchandise Intelligence, you may experience errors in your back-end job logs similar to the following: ERROR: ORACLE execute error: ORA-01438: value larger than specified precision allowed for this column. When initial http://support.sas.com/kb/37020 inventory is very small, this can cause very large values for metrics that involve division by the initial inventory value. These very large values then cannot be inserted into transaction tables because they exceed the defined precision. Some affected metrics include curr_sell_through_pct and base_sell_through_pct. There is no workaround for this issue. Select the Hot Fix tab in this note to access the hot fix for this issue.Operating System and Release InformationProduct FamilyProductSystemProduct ReleaseSAS ReleaseReportedFixed*ReportedFixed*SAS SystemSAS Markdown OptimizationMicrosoft Windows 2000 Advanced Server3.24.29.1 TS1M3 SP49.1 TS1M3 SP4Microsoft Windows NT Workstation3.24.29.1 TS1M3 SP49.1 TS1M3 SP4Microsoft Windows 2000 Professional3.24.29.1 TS1M3 SP49.1 TS1M3 SP4Microsoft Windows 2000 Datacenter Server3.24.29.1 TS1M3 SP49.1 TS1M3 SP4Microsoft Windows Server 2003 Datacenter Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4Microsoft Windows Server 2003 Enterprise Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4Microsoft Windows Server 2003 Standard Edition3.24.29.1 TS1M3 SP49.1 TS1M3 SP4Microsoft Windows Server 20083.29.1 TS1M3 SP4Microsoft Windows XP Professional3.24.29.1 TS1M3 SP49.1 TS1M3 SP4Windows Vista3.24.29.1 TS1M3 SP49.1 TS1M3 SP464-bit Enabled AIX3.24.29.1 TS1M3 SP49.1 TS1M3 SP4* For software releases th
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have https://community.oracle.com/community/developer/search.jspa?q=ORA-01438 JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page.Search this communityOracle CommunityBridged communitiesOracle BlogsOracle University TrainingOracle how to VideosOTN DocumentationOTN Search ResultsSearch forSearch forContentSearch forPeopleSearch forPlacesLast modifiedLast modifiedAll timeLast modified1 dayLast modified7 daysLast modified30 daysLast modified90 daysLast modified1 yearSort byRelevanceRelevanceLast modifiedLast modifiedRestrict results byRestrict results by: PeopleRestrict results by: PlacesSubspace depthSubspace oracle execute error depthNo subspacesSubspace depthChild subspacesSubspace depthAll subspacesMatchingMatch names onlyDeactivated UsersShow/HideShowShowAll contentShowBlog postsShowDocumentsShowDiscussionsShowPollsShowIdeasShowStatus updatesShowMessagesShowExternal activityShowShowAll placesShowSpacesShowProjectsShowGroupsContent marked asShowAll ContentShowFinalShowReservedShowCommunity RecommendedShowOutdatedShowAction ItemShowDecisionShowHelpfulShowResolvedShowCommunity Feedback RequestedSocial Search On/OffSearchSearch TipsView more results from Oracle BlogsView more results from Oracle University TrainingView more results from Oracle VideosView more results from OTN DocumentationView more results from OTN Search ResultsAbout Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout OracleOracle and SunRSS FeedsSubscribeCareersContact UsSite MapsLegal NoticesTerms of UseYour Privacy Rights© 2007-2016 Jive Software | Powered by Home | Top of pageJive Software Version: 8.0.3.1 , revision: 20160414082626.1619a91.release_8.0.3.x