RE: varchar2(300) and linewrap.......

  • From: "Foelz.Frank" <Foelz.Frank@xxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 19 Apr 2005 13:23:57 +0200

I tried the SQL Worksheet, SQL*Plus and svrmgr23. makes no difference

The story behind the scene is :

I am sending this via plsql to an external procedure (a C .dll) , which
directly sends it to a printer. The linewrap is exactly at the very =
same
position. So it prints 2 lines, although just 1 line has been sent out.

> Frank <
________________________________________________________________________=

Wichtiger Hinweis / Important Notice=20

Diese E-Mail inkl. Anh=E4nge ist vertraulich und k=F6nnte geheime =
Informationen
enthalten. Sind Sie nicht der richtige Adressat, dann unterlassen Sie =
bitte
Weiterleiten, Kopieren und Speichern dieser E-Mail sowie das =D6ffnen =
der
Anh=E4nge. Bitte l=F6schen Sie diese E-Mail von Ihrem System und =
benachrichtigen
Sie den Absender (ggf. telefonisch +49-2166-266-0). Vielen Dank.

=20

This email and any files attached are confidential and may contain
privileged information. If you are not the intended recipient, do not
forward or disclose this email, open any attachments, make any copies =
or
save this email anywhere. Please delete this email from your system and
notify the sender (maybe via phone + 49-2166-266-0). Thank you very =
much.




-----Original Message-----
From: Lex de Haan [mailto:lex.de.haan@xxxxxxxxxxxxxx]=20
Sent: Tuesday, April 19, 2005 1:16 PM
To: Foelz.Frank@xxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: varchar2(300) and linewrap.......


which tool are you using?

kind regards,

Lex.
=20
---------------------------------------------
Visit my website at http://www.naturaljoin.nl
---------------------------------------------

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx =
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Foelz.Frank

I do have a table with a varchar2(300) coloumn. Whenever I do a select =
=3D on
this, the output line gets linewrapped after the 274th. character. This
CR/LF is definitely not added within the string.

Does anybody know, if this is a "feature" of Oracle 8.0.6 on NT4 ?? How =
=3D
can I avoid this ?
--
//www.freelists.org/webpage/oracle-l

Other related posts: