Native SQL - Update statement

[michal_hrncirik]

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!

[Former Member]

Hi,

Either In ORACLE database use,

SET AUTOCOMMIT ON.

or use

EXEC SQL.

open dbcursor for

update my_table set status = :lv_status

where id like :lv_id

COMMIT WORK.

ENDEXEC.

Regards,

Anirban

[michal_hrncirik]

Hi,

I do the commit also. It does not help.

[Former Member]

then re-checkyour authorization and talk to you BASIS peer

[Former Member]

>

> 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!

try 


EXEC SQL.
                 update my_table set status = :lv_status
                 where id like :lv_id
ENDEXEC.

[michal_hrncirik]

Thank You to everyone for the response. It started to work without to change my code. Strange but true.

I got no feedback from basis, maybe they changed some setting.

Anyway, Thank You!