>Hi,
>I upsizing VFP tables to Oracle. Memo fields I create like Long Oracle datatype. But I can't insert more than 4000B. Oracle say: ORA-01704: string literal too long. Why ?
>With char or number fields I can do something like:
>Update MyTable set MyField1=MyField1 where ..., but with Long fields Oracle say: ORA-00932: inconsistent datatypes. Why ?
>Thanks, Pavel
Pavel
Oracle long binary is able to carry up to 2 gigs of the data
We kept there just full vfp projects with sources, exes, dbf etc
It is possible some mistake in upsize wizard
Upsize table manuale with the code
Vladimir
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.