Problem Note 6708: "ERROR: Oracle execute error: ORA-01403: no data found" issued when
attempting to update table using PROC DBLOAD with criteria if no rows
match the criteria
The following error message is issued with SAS Version 8, but was not
issued with SAS Version 6 while executing the exact same PROC DBLOAD
execute code. This exposes an incompatibility between SAS Version 6 and
SAS Version 8.
ERROR: Invalid SQL statement entered. See the log for details.
ERROR: ORACLE execute error: ORA-01403: no data found.
Following is an example of the code that errors with SAS Version 8 and
does not with SAS version 6:
proc dbload dbms=oracle;
user=’userid’;
orapw=’pasword’;
path=’@oracle_alias’;
sql update table set table.column=9999 where table.column=34354;
run;
A Technical Support hot fix for Release 8.2 TSLEVEL TS2M0 for this
issue is available at:
http://www.sas.com/techsup/download/hotfix/82_sbcs_prod_list.html#006708
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to Oracle | HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| Tru64 UNIX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled HP-UX | 8.2 TS2M0 | 8.2 TS2M0 |
| 64-bit Enabled AIX | 8.2 TS2M0 | 8.2 TS2M0 |
| Solaris | 8.2 TS2M0 | 8.2 TS2M0 |
| AIX | 8.2 TS2M0 | 8.2 TS2M0 |
*
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: | high |
| Topic: | SAS Reference ==> Procedures ==> DBLOAD
|
| Date Modified: | 2002-04-22 16:20:26 |
| Date Created: | 2002-01-21 11:15:31 |
