# slash / after plsql block in sql script included by sqlFile tag

**URL:** <https://forum.liquibase.org/t/slash-after-plsql-block-in-sql-script-included-by-sqlfile-tag/3309>\
**Category:** General Discussion\
**Created:** [November 26, 2015, 8:17pm UTC](https://forum.liquibase.org/t/slash-after-plsql-block-in-sql-script-included-by-sqlfile-tag/3309 "2015-11-26T20:17:00Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![roercik](https://avatars.discourse-cdn.com/v4/letter/r/f07891/32.png) [@roercik](https://forum.liquibase.org/u/roercik)\
**Post date:** [November 26, 2015, 8:17pm UTC](https://forum.liquibase.org/t/slash-after-plsql-block-in-sql-script-included-by-sqlfile-tag/3309/1 "2015-11-26T20:17:00Z")

</div>

A lot of tools like Toad generates pl/sql scripts with slash after pl/sql blocks. But liquibase adds ; after slash and after compilation object is invalid. Shouls I always manually remove slash? Is there a better way?

---

<div class="post-metadata">

**Author:** ![un1410866548036r81id](https://avatars.discourse-cdn.com/v4/letter/u/9f8e36/32.png) [@un1410866548036r81id](https://forum.liquibase.org/u/un1410866548036r81id)\
**Post date:** [November 26, 2015, 8:17pm UTC](https://forum.liquibase.org/t/slash-after-plsql-block-in-sql-script-included-by-sqlfile-tag/3309/2 "2015-11-26T20:17:00Z")

</div>

The following works fine for me:

- only put one procedure into one SQL file.   
- end the procedure definition with a / on a single line.  
  
  
  
Then use the tag to run the script and define the proper endDelimiter:  
  
  

\<sqlFile path=“create\_proc.sql”  
  
relativeToChangelogFile=“true”   
  
stripComments=“false”   
  
splitStatements=“true”   
**endDelimiter="\n/" /\>**   
  
  
  
  
Note the definition of the endDelimiter: a new line followed by a  
forward slash.  
  
  
  
If you do want to keep multiple PL/SQL CREATE statements in a single  
file, then use   
  
  
  
endDelimiter="\n/\n"  
  
  
together with splitStatements=“true”. I think that works fine  
as well. But I haven’t used that for ages.
