| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: varchar2(300) and linewrap.......
ok, what I found out so far is :
If the line has blanks in it, the line gets a chr(10) at position 221.
If I leave the blank out and fill the line completely with characters, =
it's
read correctly.
Now to the most weird thing.
If I insert/update that coloumn like this :
Insert into mytable (Headerline) values replace('1234567890.....45678
9012345,'chr(10),'');
and read the line afterwards, guess what : It's read correctly.
Seems that Oracle 8.0.6 adds a <LF> if there is a single blank in it =
and the
line is longer than 221 chars.
I will try this on my 9i machine, to see if it behaves similar.........
> Frank Foelz=A0 =D3=BF=D2 <
Phone=A0 :=A0 ++49 2166 / 266 - 837
Fax:=A0=A0=A0=A0=A0 ++49 2166 / 266 - 615
e-mail :=A0 mailto:Foelz.Frank_at_Scheidt-Bachmann.de
URL=A0=A0=A0 :=A0 http://www.scheidt-bachmann.de
________________________________________________________________________=
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: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us] =
Sent: Tuesday, April 19, 2005 2:02 PM
To: 'Foelz.Frank_at_Scheidt-Bachmann.de'; oracle-l_at_freelists.org
Subject: RE: varchar2(300) and linewrap.......
Frank,
Just for grins, so a: select substr(column,200,300) from table;
And see if you still get the line wrap. That would rule out a cr/lf =
being
in the data.
Tom
-----Original Message-----
From: Foelz.Frank [mailto:Foelz.Frank_at_Scheidt-Bachmann.de]=20
Sent: Tuesday, April 19, 2005 7:43 AM
To: oracle-l_at_freelists.org
Subject: RE: varchar2(300) and linewrap.......
Lex,
I would do this, but, as I said, the tools are representing exactly the =
=3D
same behaviour as the procedure. So this has nothing to do with any =3D
procedure at this moment.
A simple "Select OutputLine from <myTable>;" within worksheet shows me =
=3D
the same position of the linewrap.
The output looks similar like this:
Outputline
------------------------------------- ......
-----------------------------------------------------------
12345678901234567890123456789012345678.......123456
=3D
789012345678901234567890 I set charwidth to 500. Never seen this =
before.=3D20
Thx anyway
> Frank <
________________________________________________________________________=
Wichtiger Hinweis / Important Notice=3D20
Diese E-Mail inkl. Anh=3DE4nge ist vertraulich und k=3DF6nnte geheime =
=3D
Informationen enthalten. Sind Sie nicht der richtige Adressat, dann
unterlassen Sie =3D bitte Weiterleiten, Kopieren und Speichern dieser =
E-Mail
sowie das =3DD6ffnen =3D der Anh=3DE4nge. Bitte l=3DF6schen Sie diese =
E-Mail von
Ihrem System und =3D benachrichtigen Sie den Absender (ggf. telefonisch
+49-2166-266-0). Vielen Dank.
=3D20
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 =
=3D 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 =3D =
much.
-----Original Message-----
From: Lex de Haan [mailto:lex.de.haan_at_naturaljoin.nl]=3D20
Sent: Tuesday, April 19, 2005 1:34 PM
To: Foelz.Frank_at_Scheidt-Bachmann.de; oracle-l_at_freelists.org
Subject: RE: varchar2(300) and linewrap.......
... then I would debug your external procedure code,=3D20
and/or check your printer driver settings.
if the tool doesn't matter, I am afraid you can't blame Oracle ... =3D =
can't
you trap intermediate results, to exactly determine *when* the =
linewraps =3D
are added?
kind regards,
Lex.
=3D20
I tried the SQL Worksheet, SQL*Plus and svrmgr23. makes no difference =
=3D 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 =3D =
linewrap
is exactly at the very =3D3D same position. So it prints 2 lines, =
although =3D
just 1 line has been sent out.
-----Original Message-----
which tool are you using?
-----Original Message-----
I do have a table with a varchar2(300) coloumn. Whenever I do a select =
=3D =3D3D
=3D3D3D on this, the output line gets linewrapped after the 274th. =
character.
=3D This CR/LF is definitely not added within the string.
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 19 2005 - 08:53:29 CDT
 |
 |