Devart Forums

Hello,

we have problem with TSQLQuery like this:

insert into TABLE(ID,DATA) values(1,:DATAPAR)

field data is blob. If we use

SQLQuery1.ParamByName('DATAPAR').LoadFromStream(Stream,ftBlob)

and size of stream is larger than 4000 bytes then ExecSQL returns ORA-01460.

Do we have to use another way to store such a value to db or is there someting wrong?

Best regards
Zdenek, Dbexpoda30.dll 3.1.0.7, D2006, Oracle 10gR2, NET mode

In OCI mode all works ok. Prolem is in NET mode only.

Zdenek

You should change the SQL property of the TSQLQuery component to the following: You should also replace the second parameter value that you are passing to the LoadFromStream method with ftOraBlob.

It works

Thanks
Zdenek