RE: row not found --> -1403 or 100

[Zabach, Elke]

Oliver Graf wrote:   > Hi list, >  > i�m a trainee and my old sources are catching up the > SQLCODE 100 (row not found) for detecting that a cursor is at the end. > My SAPDB-cursor throws at the end the SQLCODE -1403 (row not found). > The documentation (messages_74eng.pdf) doesn�t dwell on SqlCode 100. > Can someone explain the difference between Code 100 and -1403 ??? > I just know that 100 is a system kernel message and -1403 is > an error message, but why does the cursor throw a -1403 not a 100?   Oracles 'row-not-found'-errorno is 1403  ( 1403 positive, not -1403) --> in sqlmode ORACLE 1403 can be seen.   Otherwise returncode 100 is returned.   It seems to me that you changed the sqlmode.   Elke SAP Labs Berlin