OCI8 Piecewise Fetch Example

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 - 20:51:16 CET