SQL error code -2112

[Guest_imported]

We're porting our code from a Unix platform to Windows '98. On the PC we're getting
a SQL error code of -2112 on one of our select statements. This error does not
occur in Unix, which runs fine. We are running Oracle 8.1.5 but our reference
material (version 6.0) does not contain the definition of this error code.
Does anyone know what error -2112 indicates???

 

[lfoata]

SQL-02112 SELECT..INTO returns too many rows

Cause: A SELECT...INTO statement returned more rows than can be stored in the host variable provided.

Not too familiar with windows, but it seems that you are hitting a max for a variable that Unix does not have.

 

[Guest_imported]

Thank you for your reply. Knowing that error code alerted us to the fact that our code was no declaring a cursor. This is really old code, and it never showed up as an error on Unix, but we think that's our problem on the PC. We will declare a cursor and fetch so that we are guaranteed one row at a time.

Thanks again. You've been a tremendous help, you have no idea.