Usage Note 15432: "ORA-24333: zero iteration count" error
The following error is returned from Oracle when using the "select from
connection" construction to send a query/statement with no result set
to Oracle:
ORA-24333: zero iteration count
Examples of such a queries could be CREATE, ALTER, SET, etc.
In order to avoid the error you should use "execute ( ) by oracle"
instead:
proc sql;
connect to oracle (user=scott pw=tiger);
execute (
create table newemp as select * from emp
) by oracle;
disconnect from oracle;
quit;
Operating System and Release Information
| SAS System | SAS/ACCESS Interface to Oracle | Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | |
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
| Linux | 9.1 TS1M3 | |
| 64-bit Enabled Solaris | 9.1 TS1M3 | |
| 64-bit Enabled HP-UX | 9.1 TS1M3 | |
| HP-UX IPF | 9.1 TS1M3 | |
| Linux on Itanium | 9.1 TS1M3 | |
| Microsoft Windows XP Professional | 9.1 TS1M3 | |
| 64-bit Enabled AIX | 9.1 TS1M3 | |
| Tru64 UNIX | 9.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 Note |
| Priority: | medium |
| Topic: | SAS Reference ==> LIBNAME Engines
Data Management ==> Data Sources ==> External Databases ==> Oracle
|
| Date Modified: | 2005-07-15 10:00:30 |
| Date Created: | 2005-06-02 14:58:27 |
