Problem Note 16338: Using PROC APPEND to insert rows into an Oracle table may report an
error as a note
Using PROC APPEND to append rows to an Oracle table with insertbuff > 1
can result in an Oracle error being reported incorrectly as a note. It
would look something like the following:
NOTE: ERROR: ERROR: ORACLE execute error: ORA-01400
To workaround this error, insertbuff can be set to 1, but this can cause
performance to suffer as this will insert one row at a time.
Another workaround would be to use bulkload to insert the rows:
proc append base=ora.emp (bulkload=yes) data=work.temp;
run;
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Oracle | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS1M0 |
Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 TS1M0 |
Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS1M0 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 TS1M0 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 TS1M0 |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 TS1M0 |
Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.2 TS1M0 |
Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.2 TS1M0 |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.2 TS1M0 |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.2 TS1M0 |
*
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: | Problem Note |
Priority: | medium |
Topic: | Data Management ==> Data Sources ==> External Databases ==> Oracle SAS Reference ==> LIBNAME Engines
|
Date Modified: | 2008-03-04 14:39:51 |
Date Created: | 2005-10-18 14:42:16 |