Native SQL - Update statement
I need to update one field in external database (oracle).
When I run the function which implements this update statement, I do not get any execption or error message. But when I check the record, the field is not changed.
open dbcursor for
update my_table set status = :lv_status
where id like :lv_id
The DB-user has rights to write.
Select statements are working fine.
Any idea what I am doing wrong?