Oracle Solution for Error ora-39767
ORA-39767: finish is not allowed when unloaded stream data exists
What triggered the Error:
A direct path finish was attempted when at least one stream buffer has not been completely loaded.
What should we do to fix it:
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.