Oracle Database Errors or Warnings from Error ORA-24813 to ORA-24900

SQLServerF1

ORA-24813: cannot send or receive an unsupported LOB
Cause: An attempt was made to send a LOB across the network, but either the server does not support the LOB sent by the client, or the client does not support the LOB sent by the server. This error usually occurs when the client and server are running different versions of Oracle.
Action: Use a version of the Oracle that supports the LOB on both the client and the server.
ORA-24814: operation not allowed for temporary LOBs
Cause: Temporary LOB locators are not allowed in the operation. For example: OCILobAssign only takes persistent LOB locators as parameters, not temporary LOBs.
Action: Use OCILobLocatorAssign for temporary LOBs instead. Note that OCILobLocatorAssign can also be used for persistent LOBs, in which case it will behave the same as OCILobAssign.
ORA-24815: Invalid character set form
Cause: An invalid character set form was passed into an OCI LOB function. For example, the only valid cs form for OCILobCreateTemporary() is OCI_DEFAULT(0), SQLCS_IMPLICIT(1) or SQLCS_NCHAR(2).
Action: Specify a valid character set form.

ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column
Cause: A Bind value of length potentially > 4000 bytes follows binding for LOB or LONG.
Action: Re-order the binds so that the LONG bind or LOB binds are all at the end of the bind list.
ORA-24817: Unable to allocate the given chunk for current lob operation
Cause: The given size is increased to accomodate the number of bytes from server due to varying width db char/nchar set.
Action: Use smaller chunk sizes when you have character set conversion between client/server or perform piece-wise read or write.
ORA-24850: failed to startup shared subsystem
Cause: While attempting to initialize OCI in shared mode, a problem was encountered in starting up the shared subsystem.
Action: Contact Oracle Customer support.

ORA-24851: failed to connect to shared subsystem
Cause: While attempting to initialize OCI in shared mode, a problem was encountered in connecting the process to the shared subsystem.
Action: Contact Oracle Customer Support.
ORA-24852: protocol error during statement execution
Cause: An internal protocol error occurred while receiving describe data from the server during execution of a statement.
Action: Contact Oracle Customer Support.
ORA-24853: failed to connect thread to shared subsystem
Cause: While attempting to initialize OCI in shared mode, a problem was encountered in connecting the thread to the shared subsystem.
Action: Contact Oracle Customer Support.
ORA-24854: invalid pieceinfo provided
Cause: While making the first call to write LOB data, an invalid pieceinfo value provided.
Action: Correct the call to use OCI_ONE_PIECE or OCI_FIRST_PIECE. If using OCCI, make sure to call writeBuffer before calling writeLastBuffer.
ORA-24900: invalid or unsupported mode parameter passed in call
Cause: The mode parameter passed into the OCI Client Notification call is incorrect.
Action: Please correct the mode parameter passed into OCI.

Above are list of Oracle Database Errors or Warnings from Error ORA-24813 to ORA-24900 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

Thanks,
SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.

 

Leave a Reply

Your email address will not be published. Required fields are marked *