long to varchar2

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!