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@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 - 08:59:40 CDT