Category Archives: SQL Database Error Messages

SQL-02117: Invalid SQL Cursor usage: trying to OPEN an OPENed cursor

oracle

SQL-02117: Invalid SQL Cursor usage: trying to OPEN an OPENed cursor
Cause: An attempt was made to OPEN a cursor that was already OPENed with MODE={ANSI|ANSI14|ANSI13}. An open cursor can be re-OPENed only when MODE=ORACLE
Action: When MODE={ANSI|ANSI14|ANSI13}, verify that a cursor is not already OPENed before trying to OPEN it. Specify MODE=ORACLE if an OPENed cursor is to be re-OPENed

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02116: FATAL ERROR: Reentrant code generator gave invalid context

oracle

SQL-02116: FATAL ERROR: Reentrant code generator gave invalid context
Cause: This internal error typically indicates a memory-related error
Action: Check the program for memory-related errors, such as invalid pointers or array-bounds violations

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02115: Code interpretation problem — check COMMON_NAME usage

oracle

SQL-02115: Code interpretation problem -- check COMMON_NAME usage
Cause: With PRO*FORTRAN, this error occurs if the precompiler option COMMON_NAME is specified incorrectly. With other Oracle Precompilers, this error occurs when the precompiler cannot generate a section of code
Action: With Pro*FORTRAN, when using COMMON_NAME to precompile two or more source modules, make sure to specify a different common name for each module. With other Oracle Precompilers, if the error persists, call customer support for assistance

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02114: Invalid SQL Cursor usage: trying to CLOSE a CLOSEd cursor

oracle

SQL-02114: Invalid SQL Cursor usage: trying to CLOSE a CLOSEd cursor
Cause: An attempt was made to CLOSE a cursor that was already CLOSEd with MODE={ANSI|ANSI14}. A CLOSEd cursor can be re-CLOSEd only when MODE={ORACLE|ANSI13}
Action: When MODE={ANSI|ANSI14}, verify that a cursor is not already CLOSEd before trying to CLOSE it. Specify MODE={ORACLE|ANSI13} if a CLOSEd cursor is to be re-CLOSEd

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02113: Unable to open message file

oracle

SQL-02113: Unable to open message file
Cause: SQLLIB was unable to find or open the sqllib message file sql*.msb
Action: Check that the file exists in the mesg directory and that it is readable

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02112: SELECT..INTO returns too many rows

oracle

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
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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02111: Heap consistency error

oracle

SQL-02111: Heap consistency error
Cause: This internal error typically indicates a memory-related error
Action: Check the program for memory-related errors, such as invalid pointers or array-bounds violations

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02110: Inconsistent host cache. Invalid host cache entry type

oracle

SQL-02110: Inconsistent host cache. Invalid host cache entry type
Cause: This internal error typically indicates a memory-related error
Action: Check the program for memory-related errors, such as invalid pointers or array-bounds violations

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02109: Inconsistent host cache. Host reference is out of range

oracle

SQL-02109: Inconsistent host cache. Host reference is out of range
Cause: This internal error typically indicates a memory-related error
Action: Check the program for memory-related errors, such as invalid pointers or array-bounds violations

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02108: Invalid descriptor passed to run-time library

oracle

SQL-02108: Invalid descriptor passed to run-time library
Cause: This internal error typically indicates a memory-related error
Action: Check the program for memory-related errors, such as invalid pointers or array-bounds violations

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/