Update NVARCHAR2 in Oracle 8.1.7 using VB

• • Reply

  18 years ago

  by avoutsas

  Achilleas Voutsas

  London, England, United Kingdom

  Joined 18 years ago

  Dear all,
  

  
  I have tried to update an Oracle NVARCHAR2 with no success. I am connecting to the Oracle table which has a mixture of NVARCHAR2s and VARCHAR2s using ADODB.Connection and ADODB.Recordset objects from Visual Basic.
  

  
  When trying to AddNew/Update record I get an error from Oracle ORA-12704.
  

  
  I have tried to read the type of each field and I found out, for VB the NVARCHAR2 and VARCHAR2 is adVarChar while it should have been adVarWChar and adVarChar respectively.
  

  
  Has anyone come across this issue before?
  

  
  Thanks in advance,
  

  
  Achilleas

  Report abuse