Skip to Content
0
Former Member
Jan 07, 2012 at 07:32 PM

INSERT doesn't work with EXEC SQL

305 Views

Hello Experts,

Please help me.

I have a program where I try insert data in a external database ( Oracle ), the program run normally without erros, but the data is not commited in oracle.

Is it possible de connection have a property to set some type of authorization to INSERT and UPDATE ??

see below the code:

EXEC SQL.

CONNECT TO :CONNECTION

ENDEXEC.

if sy-subrc = 0.

EXEC SQL.

SET CONNECTION :CONNECTION

ENDEXEC.

EXEC SQL.

INSERT INTO AGRICOLA.TESTE(DATA, TESTE) VALUES(SYSDATE, :sy-uname)

ENDEXEC.

EXEC SQL.

COMMIT

ENDEXEC.

EXEC SQL.

SET CONNECTION DEFAULT

ENDEXEC.

EXEC SQL.

DISCONNECT :CONNECTION

ENDEXEC.

endif.