Hello there !

I'm making some changes in a program and the following error is occurring:

When I try to make an update at my database, using Visual Basic, I get the ORA-01722: invalid number error.
When I execute the same query on PL/SQL Developer (or SQL*Plus), I don't get the error message.

Here is the query:

UPDATE SDE_GESTAO_CONECT_GRD
SET QTD_ITEM_GRD = 00049,
QTD_CONTA_MEDICA_GRD = 00004,
VAL_CONTA_MEDICA_GRD = 116.35,
IDC_TRANSMISSAO_GRD = 0
WHERE COD_LOG_GESTAO = 39282
AND NUM_GUIA_REMES_DOC = 1834

It seens to me that the problem is on "VAL_CONTA_MEDICA_GRD = 116.35", because when I change the value "116.35" to "0", it works ok.

Please, if anyone could help me I would be very grateful !

Regards,

Joka