Devart Forums

Posted: **Wed 28 Oct 2009 11:27**

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

Posted: **Thu 29 Oct 2009 07:58**

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

Posted: **Fri 06 Nov 2009 09:07**

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?

Posted: **Tue 23 Jul 2013 12:23**

"Theoretically this should not has any side effects."

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

Devart Forums

Bind String > 4000 chars?

Bind String > 4000 chars?

UseMaxDataSize / 4000 character limit

Re: Bind String > 4000 chars?