From oracle-l-bounce@freelists.org Tue Apr 19 08:07:51 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3JD7oLv018005 for ; Tue, 19 Apr 2005 08:07:51 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3JD7j4Z017983 for ; Tue, 19 Apr 2005 08:07:46 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2F22B184C99; Tue, 19 Apr 2005 07:03:37 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 15342-02; Tue, 19 Apr 2005 07:03:37 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9D7A3184202; Tue, 19 Apr 2005 07:03:36 -0500 (EST) Message-ID: From: "Mercadante, Thomas F" To: "'Foelz.Frank@Scheidt-Bachmann.de'" , oracle-l@freelists.org Subject: RE: varchar2(300) and linewrap....... Date: Tue, 19 Apr 2005 08:01:40 -0400 MIME-Version: 1.0 Content-type: text/plain X-OriginalArrivalTime: 19 Apr 2005 12:01:40.0973 (UTC) FILETIME=[8C23A1D0:01C544D7] Content-Transfer-Encoding: 8bit X-archive-position: 18596 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: thomas.mercadante@labor.state.ny.us Precedence: normal Reply-To: thomas.mercadante@labor.state.ny.us X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.1 required=5.0 tests=AWL autolearn=ham version=2.63 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@Scheidt-Bachmann.de] Sent: Tuesday, April 19, 2005 7:43 AM To: oracle-l@freelists.org 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 ;" 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@naturaljoin.nl]=20 Sent: Tuesday, April 19, 2005 1:34 PM To: Foelz.Frank@Scheidt-Bachmann.de; oracle-l@freelists.org 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. -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l