Re: long to varchar2

From: Edorta Simon <esd20_at_tid.es>
Date: Fri, 24 Sep 1999 12:25:48 +0200
Message-ID: <37EB51AC.436D876E@tid.es>

Maybe there's a simpler way to do it, but when I faced a similar problem I think I finally used PL-SQL. Insert-Select won't work because they are of different types and you can't convert types inline because there are no functions for long datatype variables.

Breno Gomes wrote:

> I successfully performed migration from FoxPro 2.5 files to
> Oracle 8.0.4.0.0.
>
> Fox memo fields were converted to long. All data are plain
> text, with 500 characters or less, due 254 fox limits.
>
> In the new application it would better to use Varchar2
> (1000) instead Long. How could I read data from long and
> write to Varchar2 ?
>
> I appreciate your suggestions.
>
> Thanks in advance.
>
> brenogomes_at_ieee.org
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Fri Sep 24 1999 - 05:25:48 CDT