Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Native SQL - Update statement

Hi all,

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.

EXEC SQL.

open dbcursor for

update my_table set status = :lv_status

where id like :lv_id

ENDEXEC.

The DB-user has rights to write.

Select statements are working fine.

Any idea what I am doing wrong?

Thnx!

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question