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

Answer / guest

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

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-13281: failure in execution of SQL statement to retrieve WKT

1 Answers  


RMAN-06499: skipping archive log file string; already backed up string time(s)

1 Answers  


IMP-00041: Warning: object created with compilation warnings

1 Answers  


TNS-00533: Connection dissolved or not yet made

1 Answers  


SQL*Loader-00118: Invalid parallel load option

1 Answers  






DRG-11879: Automatic Proxy Redirection Msut Be Explicitly Acknowledged

1 Answers  


ORA-00052: maximum number of enqueue resources (string) exceeded

1 Answers  


RMAN-03099: job cancelled at user request

1 Answers  


ORA-01304: subordinate process error. Check alert and trace logs

1 Answers  


ORA-36157: (XSMXAGGRCOMMIT) To use the AUTOCOMMIT keyword, you must also specify the AUTOUPDATE keyword.

1 Answers  


ORA-31458: an internal error occurred

1 Answers  


ORA-01103: database name 'string' in controlfile is not 'string'

4 Answers  


Categories