Problem Note 1162: No data found error may occur when trying to update oracle table
You will receive an error if you try to update an oracle table within
SQL Pass Through and the where condition is never met.
proc sql;
connect to oracle(user=username orapw=password);
execute (update dept2
set dept2.dname='NEWONE'
where dept2.dname='SALES') by oracle;
ERROR: ORACLE execute error: ORA_01403: no data found
If the column dname in the ORACLE table dept2 does not contain the
value 'SALES' for any of it's rows, the error will be given.
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#001162
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | SAS/ACCESS Interface to Oracle | 64-bit Enabled Solaris | 8 TSD1 | |
| Solaris | 8 TSD1 | |
| Linux | 8.2 TS2M0 | |
| 64-bit Enabled HP-UX | 8 TSD1 | |
| HP-UX | 8 TSD1 | |
| Tru64 UNIX | 8 TSD1 | |
| 64-bit Enabled AIX | 8 TSD1 | |
| AIX | 8 TSD1 | |
*
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: | Data Management ==> Data Sources ==> External Databases ==> Oracle
SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2002-11-01 14:00:22 |
| Date Created: | 1999-09-28 00:00:00 |
