Devart Forums

Posted: **Thu 13 Apr 2006 11:21**

Hello,
everytime we want to save CLOB Fields grater then 32k an error occurs.
After this we get

ORA-06505: PL/SQL: variable requires more than 32767 bytes of contiguous memory

on every CLOB Operation.
We use OraQuery in Delphi. The operation is like this:

         ftOraBlob: (tab.FieldByName(FieldName) as TBlobField).LoadFromStream(ss);
         ftOraClob: (tab.FieldByName(FieldName) as TMemoField).LoadFromStream(ss);

ss is an StringStream and can be greater 32k!
The error occurs at qry.Post
Thanks for any Help[/quote]

Posted: **Thu 13 Apr 2006 12:14**

Hi,
I have the same problem with last version of ODAC.

I notised if I use CLOB trough tab.GetLob(FieldName).LoadFromStream(ss) it's work better.

Posted: **Thu 13 Apr 2006 12:52**

Hallo,
das funktioniert bei mir überhauptnicht.
Das einzige was im RichEdit ankommt ist die geschweifte klammer!
Gruss
Matthias

Posted: **Fri 14 Apr 2006 08:48**

We couldn't reproduce this problem. Please send to ODAC support address complete sample that demonstrates your problem and include script to create server objects.

Devart Forums

Handle CLOB> 32k

Handle CLOB> 32k