Page 1 of 1

Direct Mode & big string parametr

Posted: Thu 08 Aug 2013 08:56
by sinys
Delphi XE2, ODAC 9.0.2 (Oracle 11)
Direct mode (with Oracle client it work fine)
Please look example

Code: Select all

begin
  -- Test statements here
  :result := 'n-oe число символов';
end;
where :result is string in/out parametr with size = 16777216 raise exception: string buffer is small

Re: Direct Mode & big string parametr

Posted: Thu 08 Aug 2013 10:41
by AlexP
Hello,

Thank you for the information, we have reproduced the problem and will investigate the reasons for this kind of behaviour.

Re: Direct Mode & big string parametr

Posted: Mon 16 Sep 2013 10:51
by AlexP
Hello,

Maximum size of VARCHAR2 in PL/SQL is 32767 (according to the ORACLE documentation: http://docs.oracle.com/cd/E11882_01/app ... atypes.htm), we support this size correctly. Using variables of a larger size is incorrect.