By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,812 Members | 875 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,812 IT Pros & Developers. It's quick & easy.

How to set up LongReadLen and LongTruncOk?

P: n/a
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;
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.