Is there a 32K limit for Host variables

From: Krishnan <krish_at_ptc.com>
Date: 1996/08/22
Message-ID: <321CC5A0.6EC1_at_ptc.com>#1/1


Hi,

Is there a 32 K limit for Host variables being passed to a PL/SQL block in a PRO*C program . I get the following error. Is there any way I can overcome this error ? Can I increase the buffer size available ? Can I use ARRAYLEN for this ( I tried using arraylen to restrict the size of the host array that enters the PL/SQL block but it still used the size of the host array to calculate the buffer size and gave me the same error )

Please Help

Krishnan
krish_at_ptc.com

  oerr ora 1044
01044, 00000, "size 39990 of buffer bound to variable %s exceeds maximum %s"
// *Cause: An attempt was made to bind a buffer whose total size would
exceed

//         the maximum size allowed.  Total array size for arrays is
//         calculated as: (element_size)*(number of elements)

// *Action: Reduce buffer size.
Received on Thu Aug 22 1996 - 00:00:00 CEST

Original text of this message