Monday 23 April 2012

ORA-24814: operation not allowed for temporary LOBs

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-24813: cannot send or receive an unsupported LOB

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-24812: character set conversion to or from UCS2 failed

ORA-24812: character set conversion to or from UCS2 failed

Cause: If the database character set is varying-width, the CLOB or NCLOB value is implicitly converted to or from UCS2. This implicit conversion failed.

Action: Contact Oracle Worldwide Support.

ORA-24811: less data provided for writing than indicated

ORA-24811: less data provided for writing than indicated

Cause: While writing into a LOB, less data was provided than indicated.

Action: If writing data in single pieces, then make sure that the buffer length specified is big enough to accommodate tha data being provided. If data is written in pieces, then make sure that all the data has been provided before specifying OCI_LAST_PIECE.

ORA-24810: attempting to write more data than indicated

ORA-24810: attempting to write more data than indicated

Cause: While writing into a LOB, more data was supplied than indicated.

Action: If data is written in pieces, then make sure that you do not provide more data in the pieces (cumulatively), than you indicated.

ORA-24809: amount specified will not fit in the lob buffers

ORA-24809: amount specified will not fit in the lob buffers

Cause: LOB buffering is enabled for the input lob locator so buffering will be used. However, the amount of lob data to read or write is larger than what the lob buffers can hold.

Action: Either disable buffering on the input lob locator and reissue the command or pass a smaller amount.

ORA-24808: streaming of lob data is not allowed when using lob buffering

ORA-24808: streaming of lob data is not allowed when using lob buffering

Cause: Attempted to stream lob data via the polling mode or a callback when lob buffering was enabled for the input lob locator.

Action: Lob buffering is useful when reading or writing small amounts of lob data so streaming should not be necessary. Rewrite the OCILobRead or OCILobWrite call so that it does not use streaming. If streaming of data is required, lob buffering should not be used. In this case, flush buffers associated with the input lob locator as necessary, disable buffering on the input lob locator and reissue the OCILobRead or OCILobWrite call.

ORA-24807: LOB form mismatch

ORA-24807: LOB form mismatch

Cause: When copying or appending LOBs, both source and desctination LOB locators should have the same character set form.

Action: Pass locators of the same character set form for copying or appending LOBs.

ORA-24806: LOB form mismatch

ORA-24806: LOB form mismatch

Cause: When reading from or writing into LOBs, the character set form of the user buffer should be same as that of the LOB.

Action: Make sure that the buffer you are using to read or write has the same form as that of the LOB.

ORA-24805: LOB type mismatch

ORA-24805: LOB type mismatch

Cause: When copying or appending LOB locators, both source and desctination LOB locators should be of the same type.

Action: Pass the same type of LOB locators for copying or appending.

ORA-24804: Lob read or write functions called while another OCI LOB read or write streaming is in progress

ORA-24804: Lob read or write functions called while another OCI LOB read or write streaming is in progress

Cause: Internal error.

Action: Wait for the ongoing LOB streaming call to finish before issuing the next server call, or use OCIBreak() abort the current LOB streaming call.

ORA-24803: illegal parameter value in lob read function

ORA-24803: illegal parameter value in lob read function

Cause: Internal error .

Action: This error should not normally occur. If it persists, please contact your customer service representative.

ORA-24802: user defined lob read callback error

ORA-24802: user defined lob read callback error

Cause: The only valid return value for a user defined lob read callback function is OCI_CONTINUE. Any other value will cause this error.

Action: Verify that OCI_CONTINUE is returned from the user defined lob read callback function.

ORA-24801: illegal parameter value in OCI lob function

ORA-24801: illegal parameter value in OCI lob function

Cause: One of the parameter values in the OCI lob function is illegal.

Action: Check every parameter in the OCI Lob function call to make sure they are correct. Offsets should be greater than or equal to one.

ORA-24795: Illegal string attempt made

ORA-24795: Illegal string attempt made

Cause: An illegal attempt was made to commit or rollback current transaction

Action: Use appropriate commit or rollback mechanism

ORA-24794: no active DTP service found

ORA-24794: no active DTP service found

Cause: Oracle RM will not serve global (distributed) transaction requests until DTP services are configured in RAC. It is possible that a service was stopped while transactions were in-flight.

Action: Provision or Start DTP services first.

ORA-24793: Test DTP service start and stop

ORA-24793: Test DTP service start and stop

Cause: internal use only

Action: none.

ORA-24792: cannot mix services in a single global transaction

ORA-24792: cannot mix services in a single global transaction

Cause: Oracle RM will not serve global (distributed) transaction requests if branches are created using different services

Action: Configure clients such that those participating in the same distributed transaction use the same service name.

ORA-24791: invalid transaction start flags

ORA-24791: invalid transaction start flags

Cause: An invalid transaction start flag was passed.

Action: Verify that OCI_TRANS_LOOSE was not passed along with OCI_ TRANS_JOIN, OCI_TRANS_RESUME.

ORA-24790: cannot mix OCI_TRANS_RESUME and transaction isolation flags

ORA-24790: cannot mix OCI_TRANS_RESUME and transaction isolation flags

Cause: An attempt was made to change the isolation level of an existing transaction.

Action: No action required

ORA-24789: start not allowed in recursive call

ORA-24789: start not allowed in recursive call

Cause: Oracle RM will not start or resume a branch in a recursive call

Action: Reconsider your application stack design

ORA-24788: cannot switch to specified transaction (server type)

ORA-24788: cannot switch to specified transaction (server type)

Cause: The transaction specified was created by a shared server and the requestor is a dedicated server, or the transaction was created by a dedicated server and the requestor is a shared server.

Action: All parts of this application should connect as dedicated or as shared.

ORA-24787: remote cursors must be closed before a call completes

ORA-24787: remote cursors must be closed before a call completes

Cause: The previous operation did not close all the remote cursors it opened. Since separated transactions are enabled, this is not allowed.

Action: Close all remote cursors in each call, or start a regular (non-separated) transaction.

ORA-24786: separated transaction has been completed

ORA-24786: separated transaction has been completed

Cause: The current transaction has been completed by another process.

Action: Start a new transaction

ORA-24785: Cannot resume a non-migratable transaction

ORA-24785: Cannot resume a non-migratable transaction

Cause: An attempt was made to resume a non-migrateable transaction.

Action: none

ORA-24784: Transaction exists

ORA-24784: Transaction exists

Cause: An attempt was made to start a transaction, while attached to a non-migrateable transaction

Action: none

ORA-24783: Cannot switch non-migratable transactions

ORA-24783: Cannot switch non-migratable transactions

Cause: An attempt was made to prepare or commit a txn different from current.

Action: none

ORA-24782: Cannot detach from a non-migratable transaction

ORA-24782: Cannot detach from a non-migratable transaction

Cause: An attempt was made to detach from a non-migrateable transaction.

Action: Either commit or rollback the transaction.

ORA-24781: branches don t belong to the same global transaction

ORA-24781: branches don t belong to the same global transaction

Cause: The list of xids passed into kpotxmp() don t have the same gtrid

Action: none

ORA-24780: cannot recover a transaction while in an existing transaction

ORA-24780: cannot recover a transaction while in an existing transaction

Cause: An attempt was made to commit or roll back a transaction while in a different transaction, and the transaction for which the action is requested is in a recovery state (this happens if it is idle too long).

Action: Detach from the current transaction and retry the operation.

ORA-24779: detach not allowed with open remote cursor

ORA-24779: detach not allowed with open remote cursor

Cause: The migratable transaction tried to detach from the current session while having an open remote cursor.

Action: Close any open remote cursor prior to detach.

ORA-24778: cannot open connections

ORA-24778: cannot open connections

Cause: The migratable transaction tried to access a remote database when the session itself had opened connections to remote database(s).

Action: Close the connection(s) in the session and then try to access the remote database from the migratable transaction. If the error still occurs, contact Oracle customer support.

ORA-24777: use of non-migratable database link not allowed

ORA-24777: use of non-migratable database link not allowed

Cause: The transaction, which needs to be migratable between sessions, tried to access a remote database from a non-multi threaded server process.

Action: Perform the work in the local database or open a connection to the remote database from the client. If multi threaded server option is installed, connect to the Oracle instance through the dispatcher.

ORA-24776: cannot start a new transaction

ORA-24776: cannot start a new transaction

Cause: An attempt was made to start a new transaction when session was already attached to an existing transaction.

Action: End the current transaction before creating a new transaction.

ORA-24775: cannot prepare or commit transaction with non-zero lock value

ORA-24775: cannot prepare or commit transaction with non-zero lock value

Cause: An attempt was made to detach the transaction with a non-zero lock value.

Action: Detach the transaction with lock value set to zero and then try to prepare or commit the transaction.

ORA-24774: cannot switch to specified transaction

ORA-24774: cannot switch to specified transaction

Cause: The transaction specified in the call refers to a transaction created by a different user.

Action: Create transactions with the same authentication so that they can be switched.

ORA-24773: invalid transaction type flags

ORA-24773: invalid transaction type flags

Cause: OCI_TRANS_TIGHT or OCI_TRANS_LOOSE mode was not specified.

Action: Verify that the right parameters are being used.

ORA-24772: Cannot mix tightly-coupled and loosely-coupled branches

ORA-24772: Cannot mix tightly-coupled and loosely-coupled branches

Cause: Application attempted to start a transaction with a global transaction identifier and a wrong option.

Action: Verify that all branches of a global transaction are started with either OCI_ TRANS_TIGHT or OCI_TRANS_LOOSE option. If the application is correct and uses distributed updates, contact customer support.

ORA-24771: cannot detach, prepare or forget a local transaction

ORA-24771: cannot detach, prepare or forget a local transaction

Cause: Service handle contains a local transaction context.

Action: Verify that the transaction context does not refer to a local transaction.

ORA-24770: cannot forget a prepared transaction

ORA-24770: cannot forget a prepared transaction

Cause: Transaction identifier refers to a prepared transaction.

Action: Verify that the identifier of a prepared transaction was not passed as an argument.

ORA-24769: cannot forget an active transaction

ORA-24769: cannot forget an active transaction

Cause: Transaction identifier refers to an active transaction.

Action: Verify that the identifier of an active transaction was not passed as an argument.

ORA-24763: transaction operation cannot be completed now

ORA-24763: transaction operation cannot be completed now

Cause: The commit or rollback cannot be performed now because the session cannot switch to the specified transaction.

Action: Retry the operation later.

ORA-24762: server failed due to unspecified error

ORA-24762: server failed due to unspecified error

Cause: An internal error has occured in the server commit protocol.

Action: Contact customer support.

ORA-24760: invalid isolation level flags

ORA-24760: invalid isolation level flags

Cause: An invalid isolation level flag was passed.

Action: Verify that only one of following values - OCI_TRANS_READONLY, OCI_TRANS_READWRITE, OCI_TRANS_SERIALIZABLE is used.

ORA-24759: invalid transaction start flags

ORA-24759: invalid transaction start flags

Cause: An invalid transaction start flag was passed.

Action: Verify that one of the following values - OCI_TRANS_NEW, OCI_ TRANS_JOIN, OCI_TRANS_RESUME was specified.

ORA-24758: not attached to the requested transaction

ORA-24758: not attached to the requested transaction

Cause: An attempt was made to detach or complete a transaction that is not the current transaction.

Action: Verify that the transaction context refers to the current transaction.

ORA-24757: duplicate transaction identifier

ORA-24757: duplicate transaction identifier

Cause: An attempt was made to start a new transaction with an identifier already in use by an existing transaction.

Action: Verify that the identifier is not in use.

ORA-24756: transaction does not exist

ORA-24756: transaction does not exist

Cause: An invalid transaction identifier or context was used or the transaction has completed.

Action: Supply a valid identifier if the transaction has not completed and retry the call.

ORA-24755: OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported

ORA-24755: OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported

Cause: These flags are currently not supported.

Action: none

ORA-24754: cannot start new transaction with an active transaction

ORA-24754: cannot start new transaction with an active transaction

Cause: An attempt to start a new transaction was made when there was an active transaction.

Action: Commit, rollback or detach the existing transaction before starting a new transaction.

ORA-24753: local transactions cannot be detached

ORA-24753: local transactions cannot be detached

Cause: An attempt to detach a local transaction was made.

Action: Local transactions may only be committed or rolled back.

ORA-24752: OCI_TRANS_NEW flag must be specified for local transactions

ORA-24752: OCI_TRANS_NEW flag must be specified for local transactions

Cause: Application attempted to start a local transaction without using OCI_ TRANS_NEW.

Action: Use OCI_TRANS_NEW when starting local transactions.

ORA-24750: incorrect size of attribute

ORA-24750: incorrect size of attribute

Cause: Transaction ID attribute size is incorrect.

Action: Verify that the size parameter is correct.

ORA-24508: Buffer is not aligned correctly.

ORA-24508: Buffer is not aligned correctly.

Cause: Alignment error ocurred in buffer when converting between character sets.

Action: Align buffer appropriately. For UTF16 buffer, pass a ub2 pointer.

ORA-24507: invalid combination of character set ids

ORA-24507: invalid combination of character set ids

Cause: Attempts to set one character set id as zero

Action: Set both charset and ncharset as zero or non-zero in OCIEnvNlsCreate()

ORA-24506: invalid attempt to change character set id on env handle

ORA-24506: invalid attempt to change character set id on env handle

Cause: Attempts to change character set id after other handles have been allocated from the env handle

Action: Change character set id after creating environment handle but before allocating any handles from it.

ORA-24505: cannot change character set id on the handle

ORA-24505: cannot change character set id on the handle

Cause: Attempts to change character set id on non-environment handles

Action: Only try to change character set id on environment handles

ORA-24504: data length larger than expected

ORA-24504: data length larger than expected

Cause: Incoming data larger than receiving buffer

Action: Set OCI_MAXDATA or MAXCHAR_SIZE appropriately or remove the setting

ORA-24503: codepoint length overflows for piecewise operation

ORA-24503: codepoint length overflows for piecewise operation

Cause: Accumulated codepoint length exceeds allowed codepoint length

Action: Set OCI_MAXCHAR_SIZE large enough to accommodate

ORA-24502: codepoint length overflows

ORA-24502: codepoint length overflows

Cause: Returned buffer has more codepoints than allowed

Action: Set OCI_MAXCHAR_SIZE large enough to accommodate