Xref: alice comp.databases.oracle.misc:34353 comp.databases.oracle.server:54521 comp.databases.oracle.tools:27051 Path: alice!news-feed.fnsi.net!news.idt.net!netnews.com!newspeer.monmouth.com!nntp2.deja.com!nnrp1.deja.com!not-for-mail From: dgallardo@my-deja.com Newsgroups: comp.databases.oracle.tools,comp.databases.oracle.misc,comp.databases.oracle.server Subject: Re: How to use OCIStmtGetPieceInfo() Date: Wed, 23 Jun 1999 17:09:18 GMT Organization: Deja.com - Share what you know. Learn what you don't. Lines: 41 Message-ID: <7kr4bj$cg6$1@nnrp1.deja.com> References: <376E6869.ABE5E614@crepido.com> X-Article-Creation-Date: Wed Jun 23 17:09:18 1999 GMT X-Http-User-Agent: Mozilla/4.51 [en] (WinNT; U) X-Http-Proxy: 1.0 x29.deja.com:80 (Squid/1.1.22) for client 199.103.165.103 Yeah, doing a piecewise fetch is a bit tricky & the doc is confusing. Read the doc of the function and the section in the OCI doc about piecewise operation carefully & attentively. I'll confess that it took me a while to get i/o from LONG RAW working too. The define handle is an output value; you need to pass the address of a pointer to a handle. I have the pointer declared as "dvoid *bndhlp" in my code and then pass its address, "&bndhlp", to the OCIStmtGetPieceInfo() function. Hope this helps...good luck! - David In article <376E6869.ABE5E614@crepido.com>, Roland Olsson wrote: > Hi, > > I have tried all day to make piecewise reads of a LONG RAW column > without success. The troublemaker here is a OCIStmtGetPieceInfo() call > which crashes all the time. The previous calls to OCIDefineByPos(), > OCIStmtExecute() and OCIStmtFetch() all work as expected. But then it > all goes down with an access violation error. > > Is there a good example anywhere how to do this? I am a bit confused by > the manuals when they talk about the 'define handle' passed to > OCIStmtGetPieceInfo(), what exactly is that? Maybe all these > simple/double pointers everwhere make me do something wrong. I have > found a lot of OCI examples/demos for Oracle 7 but they do not help me > much since I use Oracle 8. > > Some facts: WinNT 4 sp3, C, MS DevStudio97, Oracle 8i 8.1.5 > > Regards, > /Roland > Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.