Category Archives: SQL Database Error Messages

SQL-02137: Multi-threaded agent with no RETURNING clause present

oracle

SQL-02137: Multi-threaded agent with no RETURNING clause present
Cause: The EXEC SQL REGISTER CONNECT statement does not contain a RETURNING clause and the agent is running in threaded mode
Action: Re-code the statement to use a RETURNING clause that references a declared sql_context host variable

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02136: Invalid NCHAR character set id

oracle

SQL-02136: Invalid NCHAR character set id
Cause: An attempt was made to bind or define an NCHAR host variable, and the NLS_NCHAR variable was not set correctly
Action: Set the NLS_NCHAR environment variable to a valid fixed width character set id and run the application again

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02135: Unable to initialize date format using supplied mask

oracle

SQL-02135: Unable to initialize date format using supplied mask
Cause: The runtime library was unable to issue a set date format statement with the date format mask supplied
Action: Check the validity of the date format and correct if necessary. Check the ORA error number for further information

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02134: Invalid runtime context

oracle

SQL-02134: Invalid runtime context
Cause: The runtime context associated with this statement has not been properly allocated
Action: Rewrite the application to execute the EXEC SQL CONTEXT ALLOCATE statement before executing any SQL statements

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02133: Unable to initialize process for use with threads

oracle

SQL-02133: Unable to initialize process for use with threads
Cause: This is an internal error
Action: Call customer support

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02132: Unable to allocate runtime context

oracle

SQL-02132: Unable to allocate runtime context
Cause: An attempt to allocate a runtime context failed
Action: This error typically occurs when the process memory is low. Allocate more memory and run the application again

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02131: Runtime context in use

oracle

SQL-02131: Runtime context in use
Cause: Your application attempted to execute a SQL statement using a runtime context that is already in use
Action: Rewrite the application to either wait for one thread to complete before executing another SQL statement with the same runtime context, or to allocate and use a separate runtime context for each thread

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02130: EXEC TOOLS interface is not available

oracle

SQL-02130: EXEC TOOLS interface is not available
Cause: An attempt was made to link with a version of an Oracle tool that does not support the EXEC TOOLS interface. EXEC TOOLS interface
Action: Either upgrade the Oracle tool, or use the EXEC IAF interface

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02129: Fetched number of bytes is odd

oracle

SQL-02129: Fetched number of bytes is odd
Cause: The program tried to FETCH an invalid column value into a multi-byte NLS host variable. Specifically, the column did not contain valid double-byte data
Action: Make sure the column contains only double-byte data. To verify this, use SQL*Plus or Server Manager

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

SQL-02128: Sessions still exist, not logged off

oracle

SQL-02128: Sessions still exist, not logged off
Cause: A host was not removed ("logged off") from SQLLIB because XA still has sessions associated with that host
Action: Before calling SQLXDH to drop a host, XA must either drop all sessions for that host or set the "doit_anyway" flag. *Note: This error *msg* is never actually used. The error *number* is used, given as a possible return value to the sqllib xa function sqlxdh

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/