Hi,

Been trying to fix this for over a day now but can't seem to get anywhere.
Were adding Oracle as a backend for our VFP8 app (currently uses MS SQL) but we keep getting the following error when doung a table update:
'can bind a LONG value only for insert into a LONG column'

I already tried filling in all the fields but still get the same error message. We/ve also checked then NLS_LANG settings for both the server and the workstation and they've bet set to be the same.

All the above solutions were found searching MetaLink.

Were using Oracle9i Enterprise Edition Release 9.2.0.1.0 and the table structure is the following:

UIC_ID                                    NOT NULL CHAR(10)
UIC_USERID                                         VARCHAR2(10)
UIC_GROUP_ID                                       CHAR(10)
UIC_PASSWORD                                       VARCHAR2(20)
UIC_LASTSHP_ID                                     CHAR(10)
UIC_LEVEL                                          VARCHAR2(10)
UIC_FNAME                                          VARCHAR2(20)
UIC_LNAME                                          VARCHAR2(20)
UIC_TITLE                                          VARCHAR2(100)
UIG_SIGN                                           BLOB
UIC_COMPCODE                                       CHAR(10)
UIC_PASSHINT                                       VARCHAR2(60)
UIC_DFLTSCRN                                       VARCHAR2(10)
UIL_LOGGED                                NOT NULL NUMBER(1)
UIC_PASSANS                                        VARCHAR2(60)
UIC_EMAIL                                          VARCHAR2(60)
UID_CREATED                                        DATE
UID_DELETED                                        DATE
UID_UPDATED                                        DATE
UIC_DFLTROLE                                       VARCHAR2(10)
UIC_ASPCODE                                        VARCHAR2(10)
UID_PASSDATE                                       DATE
UIC_WORKSTN                                        VARCHAR2(20)
UIC_PROXYSERVER                                    VARCHAR2(60)
UIC_PROXYPORT                                      VARCHAR2(4)
UIC_PROXYUSER                                      VARCHAR2(20)
UIC_SMTPSERVER                                     VARCHAR2(60)
UIC_PROXYPWD                                       VARCHAR2(20)
UIC_PHONE                                          VARCHAR2(25)
UIN_SMTPPORT                                       NUMBER(38)
UIC_DOMLOC_ID                                      CHAR(10)
UIC_REFPREFIX                                      VARCHAR2(10)

Any help is greatly appreciated.

TIA,
Arriyel