Problem Note 38917: The error "SQL*Loader-951: Error calling once/load initialization" occurs when you use the BULKLOAD= option in SAS/ACCESS® Interface to Oracle
 |  |  |  |
In SAS/ACCESS Interface to Oracle, an error occurs when you use the BULKLOAD= option, as shown in the following code:
libname x oracle user=user–id pw=password path=path–name;
data x.aa9(dbtype=(longchcol='clob') bulkload=yes);
longchcol='aa';
run;
The error message that is generated is as follows:
NOTE: The data set X.AA9 has 1 observations and 1 variables. ************** Begin: SQL*Loader Log File ************** SQL*Loader: Release 10.2.0.1.0 - Production on Fri Jun 5 03:50:19 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL*Loader-951: Error calling once/load initialization ORA-03001: unimplemented feature
This problem occurs if you have an Oracle column that is defined as type CLOB, the Oracle encoding is in the UTF-8 encoding, and the Oracle server is release 10.1.0.2.0. In this situation, the CLOB data cannot be loaded into Oracle when you use the BULKLOAD= option.
This problem only occurs with release 10.1.0.2.0 of the Oracle server. This is an Oracle defect that has been reported.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Oracle | z/OS | 9.1 TS1M3 SP4 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | |||
| Microsoft Windows NT Workstation | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | |||
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | |||
| Windows Vista | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | |||
| HP-UX IPF | 9.1 TS1M3 SP4 | |||
| Linux | 9.1 TS1M3 SP4 | |||
| Linux on Itanium | 9.1 TS1M3 SP4 | |||
| OpenVMS Alpha | 9.1 TS1M3 SP4 | |||
| Solaris for x64 | 9.1 TS1M3 SP4 | |||
| Tru64 UNIX | 9.1 TS1M3 SP4 | |||
This error occurs when you have an Oracle column that is defined as type CLOB, the Oracle database is in the UTF-8 encoding, and the Oracle server is release 10.1.0.2.0.
| Type: | Problem Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Oracle |
| Date Modified: | 2010-06-14 15:01:29 |
| Date Created: | 2010-03-03 15:17:07 |