Bind String > 4000 chars?

[MarkF]

I'm trying to get a bind var value from a plsql routine that returns more than 4000 characters. I can get up to 4000, but any more and I get

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

My plsql code looks like:

Code: Select all

begin
  :MyVar := rpad('*',4001,'*');  -- Any val higher then 4000 fails.
  :MyVarLength := length(:MyVar);
end;

I'm using a parameter datatype of ftString. Is there a different datatype to use for plsqlstrings that could be up to 32767 chars? Thanks for any help!

-Mark

[Plash]

Set the UseMaxDataSize global variable from the OraClasses unit to False. Theoretically this should not has any side effects.

[edwin]

I'm having the same issue with one of the latest dotConnect releases.

Where can I find this setting UseMaxDataSize? Or is there another solution?

[b-b]

"Theoretically this should not has any side effects."

--> see: http://forums.devart.com/viewtopic.php?f=5&t=27581