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
// *Action: Reduce buffer size.
Received on Thu Aug 22 1996 - 00:00:00 CEST
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