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”
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.
Can you send me your xaml If its Possible or else screen shot of your workflow!
Use Insert Query like below.
insert into “your table name”(‘yourColumn names’) values (‘your column values’)
Hello I just tried it and it has inserted me into the table, I am going to prepare the .xaml for you
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.