Update not working in NATIVE SQL

[Former Member]

Hi All,

I am using the following code to update two fields in isuser.table_ table. But it is not updating the same.

EXEC SQL.
    UPDATE misuser.table_4
    SET otype = :gc_otype1,
        objid = :gc_objid
    WHERE otype = :gc_otype
  ENDEXEC.
  IF sy-dbcnt = 0.
    WRITE: 'No rows updated'.
  ELSE.
    WRITE: sy-dbcnt, 'rows updated'.
  ENDIF.

When i use the same code to update only one field, its working. Can anybody help me on this?

Thanks

Nitesh

[former_member848108]

Hi Nitesh,

Try to run the update query using the query interface(e.g. T-Sql Query Analyzer, Oracle Developer, etc.), and check

if it's working as expected. This might help yo solving the issue.

Regards.

Ozcan.