Re: problem with longvarchar... reads as long

From: Sonnich Jensen <sonnich.jensen_at_jotautomation.com>
Date: Tue, 09 Oct 2007 08:03:32 -0700
Message-ID: <1191942212.941759.264100@k79g2000hse.googlegroups.com>

On Oct 9, 5:22 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> 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: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 Received on Tue Oct 09 2007 - 10:03:32 CDT