CODEWITHSUNDEEP
oracle-databasetransactionscommitdml
Michele Cordini
Michele Cordini

Reputation: 117

In Oracle SQL will DELETE statement be commited by COMMIT in procedure called after it?

I have a procedure A where a DELETE is performed without COMMIT after it. In this same procedure A another procedure B is called after the mentioned DELETE statement. Procedure B contains just an INSERT with COMMIT. Does this COMMIT (in procedure B) apply also to the DELETE executed in procedure A?

Upvotes: 0

Views: 2334

Answers (1)

Mahamoutou
Mahamoutou

Reputation: 1555

Yes, it also does for the procedure A if and only if the procedure B is not marked as an autonomous transaction.

Upvotes: 3

Related Questions