Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

AutoCommit !

user1650289Feb 11 2020 — edited Feb 11 2020

Guys, I need help, because when executing a simple update command my pl / sql or sqldeveloper applications are already committing without being informed in the block, ex.

BEGIN

dbms_application_info.set_client_info ('i> 1 | tl> 0 |');

lms_pd.prc_executa_dml ('

update monitoring_download

set tp_situacao_descarga = '' S '' where

id_monitoramento_descarga in (10344284) ');

END;

when executing already applies the commit without the possibility of rollback, I always executed in the presented form, but this problem started from scratch.

Does anyone know how to solve?

Comments
Post Details
Added on Feb 11 2020
7 comments
177 views