Path: text.usenetserver.com!out04a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!g4g2000hsf.googlegroups.com!not-for-mail From: Mark D Powell Newsgroups: comp.databases.oracle.misc Subject: Re: problem with longvarchar... reads as long Date: Wed, 10 Oct 2007 09:07:17 -0700 Organization: http://groups.google.com Lines: 70 Message-ID: <1192032437.682917.157950@g4g2000hsf.googlegroups.com> References: <1191937560.031816.17950@y42g2000hsy.googlegroups.com> <1191939740.519538.223710@y42g2000hsy.googlegroups.com> <1191942212.941759.264100@k79g2000hse.googlegroups.com> <1191946538.678085.265080@y42g2000hsy.googlegroups.com> NNTP-Posting-Host: 69.245.97.247 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Trace: posting.google.com 1192032437 24185 127.0.0.1 (10 Oct 2007 16:07:17 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 10 Oct 2007 16:07:17 +0000 (UTC) In-Reply-To: <1191946538.678085.265080@y42g2000hsy.googlegroups.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: g4g2000hsf.googlegroups.com; posting-host=69.245.97.247; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 Xref: usenetserver.com comp.databases.oracle.misc:250189 X-Received-Date: Wed, 10 Oct 2007 12:07:17 EDT (text.usenetserver.com) On Oct 9, 12:15 pm, "fitzjarr...@cox.net" wrote: > On Oct 9, 10:03 am, Sonnich Jensen > wrote: > > > > > > > On Oct 9, 5:22 pm, "fitzjarr...@cox.net" wrote: > > > > On Oct 9, 8:46 am, Sonnich Jensen > > > wrote: > > > > > Hi > > > > > I have a problem when reading a longvarchar, displays as memo in DB > > > > Explorer. It reads, but when reading in excel it gives an error (just > > > > that). > > > > When playing around in DB explorer, I cannot use casting as char, the > > > > error: expected char, got long. > > > > > In the SQL I cannot use || and add something to it. > > > > > NVL fails too. > > > > > What should I do? > > > >http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:8... > > > Well, unfortunately I cannot create anything on the DB. That leaves me > > to find a solution on SQL only. > > Or, it is not possible to do. > > > WBR > > Sonnich- Hide quoted text - > > > - Show quoted text - > > LONG columns don't play nicely with SQL*Plus or many other tools. I > suspect you'll need to forget this if you can't process the data using > PL/SQL. Simply because someone writes a function doesn't mean you > can't apply something similar with an anonymous PL/SQL block. And it > also depends upon what you intend to do with this data once you get it > 'extracted'. > > It may well be that you can't do what you want given that you're using > a LONG column. > > David Fitzjarrell- Hide quoted text - > > - Show quoted text - 1 - What is DB Explorer? 2 - What is the length of the actual data? Just as Excel has a limit to the number of rows of data that it can handle (64k) I would think that there is also a limit to the length of any cell's data. 3 - The long data type is officially obsolete and where possible tables with long columns should be converted to using LOB columns. Just tagging along for info. -- Mark D Powell -- The Long data type is obsolete and only exists for backward compatiability.