Direct Mode & big string parametr

[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

[AlexP]

Hello,

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

[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.