Showing posts with label ORA-39767: finish is not allowed when unloaded stream data exists. Show all posts
Showing posts with label ORA-39767: finish is not allowed when unloaded stream data exists. Show all posts

Saturday, 23 June 2012

ORA-39767: finish is not allowed when unloaded stream data exists

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.