Kbase P118360: Understand why so many NO DATA FOUND are sent back from Oracle
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Understand why so many NO DATA FOUND are sent back from Oracle
GOAL:
Many "ORA-01403: no data found" between Progress DataServer and Oracle RDBMS
FIX:
When the DataServer issues a fetch request to Oracle, it receives back a success or a failure. If there is a failure, it must then make further requests to the OCI driver to determine what the failure condition is. The Oracle DataServer is heavily dependent on evaluating the 1403 return code as this lets us know important things about how to proceed with the processing of a SQL statement or a 4GL request. For instance, FIND statements (which have an implied UNIQUE) must always return at most 1 record. Error 1403 after a FIND record is retrieved lets us know that a particular FIND statement is not ambiguous, i.e., only found one exact match. We need this feedback from the SQL request or we can't evaluate the success or failure of a given FIND statement.