Problems updating Oracle database

[Liermann]

Hello

I'm trying to update a row in an Oracle database. I did it using Toad for Oracle and Sqltool and it works fine. But when I try to use Labview, the VI get stuck and i have to wait just like 5 minutes to get the error code:

Using NI Database Connectivity Toolset

Conn Execute.vi->Untitled 1<ERR>Exception occured in Microsoft OLE DB Provider for ODBC Drivers, [Oracle][ODBC][Ora]ORA-01013: o usuário solicitou o cancelamento da operação atual
.  in Conn Execute.vi->Untitled 1

Using LabSQL

Exception occured in Microsoft OLE DB Provider for ODBC Drivers, [Oracle][ODBC][Ora]ORA-01013: o usuário solicitou o cancelamento da operação atual
.  in ADO Connection Execute.vi->SQL Execute.vi->35 - Seleção de dados do banco.vi

I used this statement: update permanent set LI = '15.000', LS = '60.000'  where nome = 'testedeupdate';

The table is:

nome(primary key) LI LS

I have also used a check constraint in the database (LI<LS)

[Helmut_E]

Hi,

Are LI and LS strings or numbers. In your SQL-Statement you define them as strings ('...').
If the type is OK then remove the final ";" (Don`t ask me why, but sometimes this will work with ORACLE)

Best regards, Helmut