problems with sql*loader

From: Gary Turner <gary.turner_at_sanmina-sci.com>
Date: Tue, 7 May 2002 11:00:25 -0500
Message-ID: <gNSB8.66172$To6.19964510@e420r-atl1.usenetserver.com>

has anyone ever encountered this error before.

SQL*Loader-961: Error calling once/load finishing for table DMND90D ORA-26095: unprocessed stream data exists

ORA-26095 unprocessed stream data exists Cause: Either a OCIDirPathLoadStream call was made which provided more stream data prior to the server being able to fully process the stream data that it already has, or a OCIDirPathFinish call was made when the server had unprocessed stream data.

Action: Most likely an application misuse of the direct path API. Make sure that the stream is not being reset inadvertently prior to any previous stream data being processed, or, that OCIDirPathFinish is not being called prematurely (that is, stream pushed, error encountered and LoadStream not called to process the remainder of the stream before Finish is called).

this only happens using direct load. if i use conventional the table loads.

i am using Oracle9i Enterprise Edition Release 9.0.1.0.0

is there some patch i might need to apply?? Received on Tue May 07 2002 - 11:00:25 CDT