When I save a HTML file to ORACLE 10g,the ORA-01460 error occured

[afy]

Hi
I want to store files in oracle,use ODA Trial Edition 6.25.0.12 for Delphi to write the programe.It can run well with ORACLE8 ,9 ,9i.when the program run with ORACLE 10g,it can save all types of file,except HTML. the Error is 'ORA-01460: unimplemented or unreasonable conversion requested'
this is my code:
OraQuery1.Connection:=OraSession1;
OraQuery1.Close;
OraQuery1.SQL.Clear;
s:='E:\ODAC\a.htm';

OraQuery1.SQL.Add('insert into a (htm,reportid,languagecode) values (:aClob,1,''endd'')');
OraQuery1.Params.ParamByName('aClob').AsBlobRef.LoadFromFile(s);
OraQuery1.ExecSQL;

[Plash]

You should either set TemporaryLobUpdate option of TOraQuery to True, or change SQL text to the following:

Code: Select all

insert into a (htm,reportid,languagecode)
values (empty_clob(), 1, 'endd')
returning htm into :aClob