How to set up LongReadLen and LongTruncOk?
I'm developing in ASP NET and trying to read a LONG RAW column from an Oracle Table.
I get this error: "ORA-01406: fetched column value was truncated... " . I read that you can avoid this error setting up LongReadLen and LongTruncOk... but how and where? Could I do it in my oracle stored procedure? Or do I have to set up it on my ASP NET application... Thanks! (I'm using W2003 Server)
PROCEDURE SP_LISTAR_REP (R_NUEVO OUT CUR_PKG_REPRESENTANTES,
i_cod IN INTEGER)
--LongTruncOk:=0 ; -- Here ?
OPEN R_NUEVO FOR
SELECT R.cod_op As cod_op,
R.cod_rep As cod_rep,
R.img_repres As img_repres
FROM TBL_REPRESENTANTES R,
WHERE R.cod = i_cod