Implicit commit when i execute stored procedure from sqldeveloper
Hi, I'am executing a stored procedure whitout commit or rollback, i have executed this from sqldeveloper and when i review i look the register there is in the table
- create or replace NONEDITIONABLE PROCEDURE pruebac AS
BEGIN
insert into system.prueba values (11);
END pruebac;
2. SQL> exec pruebac;
PL/SQL procedure successfully completed.
SQL> disc
Disconnected from Oracle Database 19c Standard Edition 2 Release 19.0.0.0.0 - Production
Version 19.20.0.0.0
3. open new connection
4. I look new record
SQL> select * from system.prueba;
A
1
2
3
4
5
6
7
10
10
11
10 rows selected.
Why, this row is saving in the table? without commit or rollback.