Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
I cannot add more than 4000B to the LONG Oracle datatype
Message
De
22/10/1999 07:03:16
Vladimir Zhuravlev
Institute of the Physics of Earth,Russia
Moscow Region, Russie
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00279814
Message ID:
00279816
Vues:
10
>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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform