RE: varchar2(300) and linewrap.......
- From: "Mercadante, Thomas F" <thomas.mercadante@xxxxxxxxxxxxxxxxx>
- To: "'Foelz.Frank@xxxxxxxxxxxxxxxxxxx'" <Foelz.Frank@xxxxxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 19 Apr 2005 08:01:40 -0400
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@xxxxxxxxxxxxxxxxxxx]
Sent: Tuesday, April 19, 2005 7:43 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: varchar2(300) and linewrap.......
Lex,
I would do this, but, as I said, the tools are representing exactly the =
same
behaviour as the procedure. So this has nothing to do with any =
procedure at
this moment.
A simple "Select OutputLine from <myTable>;" within worksheet shows me =
the
same position of the linewrap.
The output looks similar like this:
Outputline
------------------------------------- ......
-----------------------------------------------------------
12345678901234567890123456789012345678.......123456
=
789012345678901234567890
I set charwidth to 500. Never seen this before.=20
Thx anyway
> 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:34 PM
To: Foelz.Frank@xxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: varchar2(300) and linewrap.......
... then I would debug your external procedure code,=20
and/or check your printer driver settings.
if the tool doesn't matter, I am afraid you can't blame Oracle ... =
can't you
trap intermediate results, to exactly determine *when* the linewraps =
are
added?
kind regards,
Lex.
=20
---------------------------------------------
Visit my website at http://www.naturaljoin.nl
---------------------------------------------
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 =3D same position. So it prints 2 lines, although =
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
on this, the output line gets linewrapped after the 274th. character. =
This
CR/LF is definitely not added within the string.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
