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

Home -> Community -> Usenet -> c.d.o.misc -> Re: problem with longvarchar... reads as long

Re: problem with longvarchar... reads as long

From: <fitzjarrell_at_cox.net>
Date: Tue, 09 Oct 2007 07:22:20 -0700
Message-ID: <1191939740.519538.223710@y42g2000hsy.googlegroups.com>


On Oct 9, 8:46 am, Sonnich Jensen <sonnich.jen..._at_jotautomation.com> 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:839298816582

David Fitzjarrell Received on Tue Oct 09 2007 - 09:22:20 CDT

Original text of this message

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