OCI8 Piecewise Fetch Example

From: Massis Isagholian <massis_at_isagholian.com>
Date: Tue, 25 Feb 2003 19:51:16 GMT
Message-ID: <UOP6a.417$Uy4.37035@bgtnsc05-news.ops.worldnet.att.net>

I'm confused by the OCI8 documentation regarding piecewise fetch operations.

Do you have to know the actual size of a LONG column in order to perform a piecewise operation? If so, is there a way to determine the actual amount of the data stored in a LONG column without tracking it yourself? How are columns in a query that are not involved with the piecewise fetch handled in a piecewise operation?

Can anyone provide a C-lang example of an OCI8 piecewise fetch? It would be extremely helpful to see an example of a fetch operation involving a CHAR column in addition to a LONG column being processed in a piecewise manner.

Thanks for your help.
Massis Received on Tue Feb 25 2003 - 13:51:16 CST