Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: varchar2(300) and linewrap.......

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

From: Foelz.Frank <Foelz.Frank_at_Scheidt-Bachmann.de>
Date: Tue, 19 Apr 2005 13:23:57 +0200
Message-ID: <184C07CA956B59418F925AACD4DF4CDE033919C0@mail-server.iiv.scheidt-bachmann.de>


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_at_naturaljoin.nl]=20 Sent: Tuesday, April 19, 2005 1:16 PM
To: Foelz.Frank_at_Scheidt-Bachmann.de; oracle-l_at_freelists.org 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_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
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 ?

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Apr 19 2005 - 07:28:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US