Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle Database Error: SQL-02112      [Return To Oracle Error Index] Jump to:  
Oracle Error: SQL-02112

Error Description:
SELECT..INTO returns too many rows

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

Action:
There are 3 possible solutions:

1. Use the precompiler option select_error=no.

2. Declare a host variable with a larger array dimension.

3. Declare a cursor or cursor variable for the select statement.

.


There haven't been any comments added for this error yet. You may add one if you like.  Add a comment 
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 51 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?