CLOB data Select error

eric92 · Post by **eric92** » Wed 26 Oct 2005 07:32

Using
ODAC version 5.55.1.24
delphi 7
oracle 9i

Setting
OraSession1.Options.Net := True;
OraSession1.Options.CharLength := 0;
OraSession1.Options.Charset := '';
OraSession1.Options.UseUnicode := True;

application query:
select CLOB_FIELD_TEST from CLOBTABLE where Id = :Id
(CLOB_FIELD_TEST is Clob field)

application code:
SmartQuery1.ParamByName(Id').AsString := IdNumber;

try
SmartQuery1.Execute; <- this line find error
except
end;

...
...

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

why??

Paul · Post by **Paul** » Thu 27 Oct 2005 07:18

We cannot reproduce your problem with ODAC version 5.55.1.24,Oracle server 9.2.0.1, NLS_CHARACTERSET=AL32UTF8.
Possibly this depends on particular data in CLOB field. Please note that UseUnicode := True assumes that the value of CLOB is assigned in UTF16 (WideString) format on client side.
After this error you must restart Oracle server in most cases to avoid this error next time with Net option connection.