Devart Forums

Hi,

I'm loading a stream into a blob parameter and when the size exeeds 32K I get ORA-01460 error.

OraStoredProc.StoredProcName := 'SM_IS_REPORTMANAGER.SAVEREPORTRESULT';
..
..
OraStoredProc.ParamByName('ResultData').LoadFromStream(Ms, ftBlob);
..
..
OraStoredProc.ExecProc;

I've also tried using LoadFromFile and

vClob := TOraLob.Create(FOracleDBSession_Kerfi.OCISvcCtx);
vClob.CreateTemporary(ltClob);
vClob.LoadFromStream(ms);
vClob.WriteLob;
OraStoredProc.ParamByName('ResultData').AsOraClob:= vClob;


Does anyone know a solution for this?

PS. I'm using version 5.55.0.21

What is a type of parameter in procedure declaration?
ftBlob - corresponds to LONGRAW Oracle type
ltClob - corresponds to CLOB type
Possibly you must use ftOraBlob and ltBlob for BLOB Oracle type.