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.