Re: using host arrays in PRO*C

Shneor Berezin (sber_at_netcom.com) wrote:
> I wonder how the dimension of host arrays in PRO*C is determined by Oracle.
> Looking at the generated C code, only the address of the array is being
> passed to sqlcex.
> The dummy at Oracle technical support told me, that this is proprietary
> information and I don't need to know. Unbelievable!!!
> Personally, I don't know of any reliable way of determining the size of
> an array allocated on the heap. Has anybody tried to use a host array
> allocated on the heap? Would it help if I use a FOR clause?

*probably* by using the sizeof feature of the compiler. That is how charater arrays (strings) are processed .. and that is no propriety info since oralce manuals tell that.

--
**************************************************************
*                          Saad Ahmad                        *
*                          McHugh Freeman & Associates, Inc. *
*                          Ph:  (414) 798-8606 Ext. 457      *
*                          Fax: (414) 798-8619               *
*                          E-Mail: sahmad_at_mfa.com            *
**************************************************************