# Changeset options for oracle

**URL:** https://forum.liquibase.org/t/changeset-options-for-oracle/6123
**Category:** General Discussion
**Created:** [November 2, 2021, 9:23pm UTC](https://forum.liquibase.org/t/changeset-options-for-oracle/6123 "2021-11-02T21:23:26Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![kalyandrug](https://avatars.discourse-cdn.com/v4/letter/k/f0a364/32.png) [@kalyandrug](https://forum.liquibase.org/u/kalyandrug)
#### Post date: [November 2, 2021, 9:23pm UTC](https://forum.liquibase.org/t/changeset-options-for-oracle/6123/1 "2021-11-02T21:23:26Z")

</div>

I want to ignore some of the ORA errors , How to specify ignore those errors . what to specify changeset .

please share what are the options exists in changeset .

Regards ,  
Ramesh

---

<div class="post-metadata">

### Author: ![aditi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/aditi/32/356_2.png) [@aditi](https://forum.liquibase.org/u/aditi)
#### Post date: [November 4, 2021, 6:54pm UTC](https://forum.liquibase.org/t/changeset-options-for-oracle/6123/2 "2021-11-04T18:54:17Z")

</div>

Hi @kalyandrug,

You need to add `WHENEVER SQLERROR CONTINUE` inside your changeset, and configure your changeset to use `runWith:sqlplus` .

---

<div class="post-metadata">

### Author: ![rgrzegorczyk](https://avatars.discourse-cdn.com/v4/letter/r/977dab/32.png) [@rgrzegorczyk](https://forum.liquibase.org/u/rgrzegorczyk)
#### Post date: [November 5, 2021, 8:04am UTC](https://forum.liquibase.org/t/changeset-options-for-oracle/6123/3 "2021-11-05T08:04:32Z")

</div>

Hello @kalyandrug .

When using Liquibase Open Source Version - I often add “failOnError:false” to my SQL changesets.  
e.g. when I want to add some SQLcl commands to my changesets and have them in my UpdateSQL scripts - normally it would fail when running “liquibase update”, but thanks to this parameter I can have it added to my generated SQL script.