How to set up LongReadLen and LongTruncOk?
From: Jorge_Beteta <jbeteta_at_yahoo.com>
Date: 11 May 2004 06:59:40 -0700
Message-ID: <5140b91e.0405110559.430c221b_at_posting.google.com>
Hello,
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)
BEGIN
--LongTruncOk:=0 ; -- Here ?
OPEN R_NUEVO FOR
SELECT R.cod_op As cod_op,
WHERE R.cod = i_cod
END SP_LISTAR_REP; Received on Tue May 11 2004 - 15:59:40 CEST
Date: 11 May 2004 06:59:40 -0700
Message-ID: <5140b91e.0405110559.430c221b_at_posting.google.com>
Hello,
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)IS
BEGIN
--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
END SP_LISTAR_REP; Received on Tue May 11 2004 - 15:59:40 CEST