473,320 Members | 1,722 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to set up LongReadLen and LongTruncOk?

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
0 2259

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Costas Menico | last post by:
I have an Access database and a table. One of the columns was a memo field. If I execute a 'select * from table', all the rows would be retrieved but the columns after the memo column had null...
3
by: newtechiebug | last post by:
I am really new with Perl and I am trying to write data from an Oracle database to an Excel Spreadsheet simply by clicking on a link. I have read over CPAN Spreadsheet::WriteExcel and I really am...
1
by: cloverlano | last post by:
An existing perl script was working fine. However on a new linux server the text that is retrieved from a varchar 5000 column is being truncated. Apparently the Perl version is the same. When I...
0
by: Jorge_Beteta | last post by:
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...
3
by: jonathan184 | last post by:
The code seems to be working fine for some records but I am thinking it is finding some other records with special characters and so on. I am looking for a way to insert the xml string with escaping...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.