# How to implement autonomous transaction

**URL:** <https://discourse.getdbt.com/t/how-to-implement-autonomous-transaction/6397>\
**Category:** Help\
**Tags:** jinja\
**Created:** [January 29, 2023, 9:00am UTC](https://discourse.getdbt.com/t/how-to-implement-autonomous-transaction/6397 "2023-01-29T09:00:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![ashish.agrawal.inbox](https://sea2.discourse-cdn.com/flex020/user_avatar/discourse.getdbt.com/ashish.agrawal.inbox/32/1759_2.png) [@ashish.agrawal.inbox](https://discourse.getdbt.com/u/ashish.agrawal.inbox)\
**Post date:** [January 29, 2023, 9:00am UTC](https://discourse.getdbt.com/t/how-to-implement-autonomous-transaction/6397/1 "2023-01-29T09:00:18Z")

</div>

## The problem I’m having

I want to commit only the part of code which is called. Like there are 4 update statements made one after another as shown in code. But when I write commit; I want only 3rd one to commit and not 1st and 2nd.  
Similar thing is achieved in Oracle using autonomous transaction.

## The context of why I’m trying to do this

## What I’ve already tried

## Some example code or error messages

```auto
<update sql>
<update sql>
<update sql>
<update sql>

```