Hi,
I hav Delphi XE and I have a dbexpress Oracle connection ( ConnectionName =ORACLECONNECTION, Driver = Oralce, Library Name = dbxora.dll). At design time I connect to Oracle XE 11g and see my data on a grid ( using a clientdataset) . I run the program and see my data on the grid but if I try to change the data and call the save button with the following code when I trace into ClientDataSet1.ApplyUpdates I get the error  "TDBXError with message Ora- 01722: Invalid number.  ( My database table has three fiel
ds (  one of type NUMBER(10) and two fields of type NVARCHAR2(30) ).  I would appreciate if someone could Help me .  Thank you


SQLConnection1.StartTransaction(td);
    try
      if ClientDataSet1.ApplyUpdates(0) > 0 then
         raise exception.Create('Problem in Save');
      SQLConnection1.Commit(td);
    except
      SQLConnection1.Rollback(td);
    end;

I suggest you use the TSQLMonitor and see what SQL is being used. 
Somehow that SQL appears to be causing your error.

Nick Lazidis wrote:
> I hav Delphi XE and I have a dbexpress Oracle connection ( ConnectionName =ORACLECONNECTION, Driver = Oralce, Library Name = dbxora.dll). At design time I connect to Oracle XE 11g and see my data on a grid ( using a clientdataset) . I run the program and see my data on the grid but if I try to change the data and call the save button with the following code when I trace into ClientDataSet1.ApplyUpdates I get the error  "TDBXError with message Ora- 01722: Invalid number.  ( My database table has three fi
el
> ds (  one of type NUMBER(10) and two fields of type NVARCHAR2(30) ).  I would appreciate if someone could Help me .  Thank you