Handle CLOB> 32k

Matthias · Post by **Matthias** » 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]

nschmied · Post by **nschmied** » 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.

Softchaos67 · Post by **Softchaos67** » Thu 13 Apr 2006 12:52

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

Challenger · Post by **Challenger** » 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.