Execute Query: ERROR ORA-00936, an expression is missing

[Aguirre]

Hello I am doing tests to make an update on a database and I get the error “Execute Query: ERROR [HY000] [Oracle] [ODBC] [Ora] ORA-00936: an expression is missing”
It is a simple process, in which I read an excel, assign it and perform the update, but it gives me an error. any idea what can it be?

Greetings and thank you.

“UPDATE archivos2 a
SET a.empleado =@EMPLEADO
Where a.id = @ID”

[pravin_calvin (pravin kumar)]

Hi @Aguirre

Please refer to the screenshot below.

Regards

[Aguirre]

@pravin_calvin

Please refer to the screenshot below.

Hello and thanks for the help, now I get this error.
the two numbers that appear above are the ones read from the excel file and that I want to insert.

[pravin_calvin (pravin kumar)]

Hi @Aguirre

Can you send me your xaml If its Possible or else screen shot of your workflow!

Thanks

[pravin_calvin (pravin kumar)]

Hi @Aguirre

Use Insert Query like below.

insert into “your table name”(‘yourColumn names’) values (‘your column values’)

Regards

[Aguirre]

@pravin_calvin

Use Insert Query like below.

insert into “your table name”(‘yourColumn names’) values (‘your column values’)

Regards

Hello I just tried it and it has inserted me into the table, I am going to prepare the .xaml for you

[Aguirre]

Solved.
The problem that was using the wrong activity, to perform “Update” you have to use “Execute NON Query”. I work with an Oracle database
Thanks for the help @pravin_calvin