Oracle Database Errors or Warnings from Error ORA-39761 to ORA-39771


ORA-39761: stream reset required before loading this stream again
Cause: An attempt was made to load a stream that was previously loaded but has not been reset yet.
Action: Reset the specified stream and convert column array data to it before attempting to load it again.
ORA-39762: streams must be loaded in conversion order
Cause: An attempt was made to load a stream out of conversion order.
Action: Load streams in the same order they were converted.
ORA-39763: stream must be completely loaded before it is reset
Cause: An attempt was made to reset a stream that contains converted column array data and hasn’t been completely loaded yet.
Action: Before resetting a stream, load it until a status of OCI_SUCCESS, OCI_NO_DATA, or OCI_NEED_DATA is returned.

ORA-39764: specified stream is not in the specified direct path context
Cause: A direct path operation was attempted using a stream that was not created in the specfied direct path context.
Action: Only use streams created in the specified direct path context.
ORA-39765: stream must be reset before used in a column array conversion
Cause: The stream was completely loaded, but has not been reset yet.
Action: Reset loaded streams after load returns OCI_SUCCESS, OCI_NO_DATA, or OCI_NEED_DATA. The stream can then be used in a column array to stream conversion.
ORA-39766: invaid stream specified for column array conversion
Cause: A stream must be loaded and reset before used again in a column-array-to-stream conversion. This error is issued if another stream has subsequently been converted before the specified stream has been loaded, or if the latest load of this stream returned OCI_ERROR.
Action: Don’t convert into a previous stream before it is loaded. Also, when load stream returns OCI_ERROR, the stream must be loaded again to insure any remaining information in the stream is loaded. The stream must be loaded even if the last or only row was in error. There may be error information in the stream that needs to be sent to the server.

ORA-39767: finish is not allowed when unloaded stream data exists
Cause: A direct path finish was attempted when at least one stream buffer has not been completely loaded.
Action: All streams must be loaded after a column array to stream conversion until load stream returns a status of OCI_SUCCESS or OCI_NO_DATA. The load can then be finished.
ORA-39768: only one direct path context top level column array is allowed
Cause: Attempt to create multiple top level column arrays in a direct path context, when only one is allowed.
Action: Create another direct path context if additional top level column arrays are required.
ORA-39769: finish is not allowed with an incompletely loaded last row
Cause: Part of a row has been loaded, but it is not complete.
Action: Finish loading the current row when load stream returns OCI_ERROR or OCI_NEED_DATA.
ORA-39771: stream must be loaded before its handle is freed
Cause: An attempt was made to free a stream handle after conversion but before the stream was loaded.
Action: Load the stream until OCI_SUCCESS, OCI_NEED_DATA or OCI_NO_DATA is returned before attempting to free the stream handle. If OCI_NEED_DATA is returned, another stream must be loaded to complete last row.

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

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase 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.

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 *