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

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

Oracle Error Message

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

Reason for the Error

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

Solution

Lob buffering is useful when reading/writing small amounts of lob data so streaming should not be necessary. Rewrite the OCILobRead/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/OCILobWrite call.

Share:

Leave A Reply

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

You May Also Like

Oracle Error Message CLSGN-32767: Internal error. Reason for the Error An unexpected error occurred. Solution Examine the message(s) that accompany...
Oracle Error Message CLSGN-00211: OCR batch operation failed. string Reason for the Error Setting a set of Oracle Cluster Registry...
Oracle Error Message CLSGN-00210: failed to get value for OCR key “string”. string Reason for the Error It was not...