Zeoslib Portal

Hi,

i know that the last post is a few month ago, but has someone a
solution for reading BLOB-fields?

I use Oracle9i and I can save the files in the db. But if I read the
blob-fields I also get the error "ORA-01406: fetched column value was truncated"

Thanks,

Rainer

Hi,

how do you create the view? With a TZSQLProcessor?
If I create a trigger with a TZSQLProcessor the same error occurs.
http://zeos.firmos.at/viewtopic.php?t=680

Is there a message if you test your sql-query in SQL*Plus?

Rainer

Hi, for me it worked with this hack: ZDBcOracleStatement.pas: [...] procedure TZOraclePreparedStatement.Prepare; var I: Integer; Status: Integer; TypeCode: ub2; CurrentVar: PZSQLVar; begin if not Prepared then begin { Allocates statement handles. } if (FHandle = nil) or (FErrorHandle = nil) then beg...

Hi,

did you find a solution for that problem?
I've got the same error on reading a Blob-Field from a table.

But no solution

Thanks,

Rainer