Re: Question about OCI 8 handles.

In article <txAd2.431$UY2.2496164_at_newsfeed.intelenet.net>,   "Will Hartung" <Will.Hartung_at_msoft.com> wrote:
> My first cut at calling OCIDefineByPos is blurting about an invalid handle.
> It only requires 3 handles, the statement, define and error handle. Define
> is a null pointer (like the examples), and the others are...well...handles,
> I guess.
>
> I couldn't say whether it's the error handle for the statement handle that
> is having the problem, save that they both seem to work in an earlier
> OCIBindByName call.
>
> Here's the relevant snippet:
>
> OCIDefine *defnp = NULL;

// Here is a key
 OCIHandleAlloc( stmthp,(void ** ) &defnp,OCI_HTYPE_BIND,1,(void ** ) &tmp);

        {
> sword swResult = OCIDefineByPos(stmthp, &defnp, errhp,
> nPos, pObject, nLength, swType, pIndicators, NULL, NULL, OCI_DEFAULT);
>
> Any ideas?
>
> Thanx!
>
> Will Hartung
> (willh_at_msoft.com)

Hi,
Try to implicitly allocate bind handle (see above). It must work.

Best regards,
Victor Stolbovoy

P.S.: Never believe in docs.

&#137;

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Dec 16 1998 - 12:04:34 CST