# \<\> \> \< symbols not working in liquibase XML format

**URL:** <https://forum.liquibase.org/t/symbols-not-working-in-liquibase-xml-format/4795>\
**Category:** General Discussion\
**Created:** [November 11, 2020, 11:04am UTC](https://forum.liquibase.org/t/symbols-not-working-in-liquibase-xml-format/4795 "2020-11-11T11:04:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![joeljoejoseph](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@joeljoejoseph](https://forum.liquibase.org/u/joeljoejoseph)\
**Post date:** [November 11, 2020, 11:04am UTC](https://forum.liquibase.org/t/symbols-not-working-in-liquibase-xml-format/4795/1 "2020-11-11T11:04:31Z")

</div>

if any \> \< symbols inside an sql script. Any workaround

 BEGIN FOR t1 IN (SELECT ID FROM EMP ) LOOP update EMP set ID=ID+1 where id=t1.id and 1 \<\>2 ; COMMIT; END LOOP; DBMS\_OUTPUT.PUT\_LINE('SUCCESS'); EXCEPTION WHEN OTHERS THEN ROLLBACK; DBMS\_OUTPUT.PUT\_LINE('ERROR - ' || sqlerrm); END; /

---

<div class="post-metadata">

**Author:** ![rakhi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/rakhi/32/288_2.png) [@rakhi](https://forum.liquibase.org/u/rakhi)\
**Post date:** [November 19, 2020, 9:29am UTC](https://forum.liquibase.org/t/symbols-not-working-in-liquibase-xml-format/4795/2 "2020-11-19T09:29:10Z")

</div>

Hi @joeljoejoseph,

> [@joeljoejoseph](#):
>
> if any \> \< symbols inside an sql script

I had the same issue in one of my use cases. I wrapped the SQL script inside `<![CDATA[]]>` tag, it worked for me.

> [CDATA](http://www.w3.org/TR/REC-xml/#sec-cdata-sect) stands for [Character Data](http://www.w3.org/TR/REC-xml/#dt-chardata) and it means that the data in between these strings includes data that _could_ be interpreted as XML markup, but should not be.

May be you can give it a try as below:

`\<![CDATA[

BEGIN FOR t1 IN (SELECT ID FROM EMP ) LOOP update EMP set ID=ID+1 where id=t1.id and 1 \<\>2 ; COMMIT; END LOOP; DBMS\_OUTPUT.PUT\_LINE(‘SUCCESS’); EXCEPTION WHEN OTHERS THEN ROLLBACK; DBMS\_OUTPUT.PUT\_LINE('ERROR - ’ || sqlerrm); END;

]]\>`

Please check the SQL script I copied doesn’t miss anything which is expected before giving it a try.

Let me know if this helped.

Thanks,  
Rakhi Agrawal

---

<div class="post-metadata">

**Author:** ![joeljoejoseph](https://avatars.discourse-cdn.com/v4/letter/j/46a35a/32.png) [@joeljoejoseph](https://forum.liquibase.org/u/joeljoejoseph)\
**Post date:** [January 18, 2021, 8:40am UTC](https://forum.liquibase.org/t/symbols-not-working-in-liquibase-xml-format/4795/3 "2021-01-18T08:40:03Z")

</div>

Thanks its worked for me

---

<div class="post-metadata">

**Author:** ![rakhi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/rakhi/32/288_2.png) [@rakhi](https://forum.liquibase.org/u/rakhi)\
**Post date:** [January 18, 2021, 10:19am UTC](https://forum.liquibase.org/t/symbols-not-working-in-liquibase-xml-format/4795/4 "2021-01-18T10:19:29Z")

</div>

Great! Happy to know that!