topic Native SQL - Update statement in Application Development and Automation Discussions

Native SQL - Update statement

michal_hrncirik — Mon, 08 Sep 2008 08:09:01 GMT

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!

Re: Native SQL - Update statement

Former Member — Mon, 08 Sep 2008 08:13:00 GMT

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

Re: Native SQL - Update statement

michal_hrncirik — Mon, 08 Sep 2008 08:23:03 GMT

Hi,

I do the commit also. It does not help.

Re: Native SQL - Update statement

Former Member — Mon, 08 Sep 2008 08:30:39 GMT

then re-checkyour authorization and talk to you BASIS peer

Re: Native SQL - Update statement

Former Member — Tue, 09 Sep 2008 07:24:39 GMT


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

Re: Native SQL - Update statement

michal_hrncirik — Fri, 24 Oct 2008 09:58:38 GMT

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!