# Creating packages and packages bodies with the same file **URL:** \ **Category:** General Discussion\ **Created:** [December 2, 2009, 4:25pm UTC](https://forum.liquibase.org/t/creating-packages-and-packages-bodies-with-the-same-file/372 "2009-12-02T16:25:00Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forum.liquibase.org/u/Guest)\ **Post date:** [December 2, 2009, 4:25pm UTC](https://forum.liquibase.org/t/creating-packages-and-packages-bodies-with-the-same-file/372/1 "2009-12-02T16:25:00Z")
Hey guys, Just FYI, For creating package spec and body with the same file, Liquibase works great with following changeLog: http://forum.liquibase.org/topic/oracle-end-delimiter-issue Thanks for a great tool! Chang-Il ---
**Author:** ![nullpointer\_lb](https://avatars.discourse-cdn.com/v4/letter/n/e274bd/32.png) [@nullpointer\_lb](https://forum.liquibase.org/u/nullpointer_lb)\ **Post date:** [December 2, 2009, 4:25pm UTC](https://forum.liquibase.org/t/creating-packages-and-packages-bodies-with-the-same-file/372/2 "2009-12-02T16:25:00Z")
Hi, I am would like to put package declaration and package body in one sql file and then invoke it in sqlfile tag my sql file CREATE PACKAGE mypackage IS ... END; / CREATE PACKAGE BODY mypackagebody IS … END; / But it does not create package body, it looks like it puts everything into package  declaration. It seems it ignores '/' as a end delimiter. ---
**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\ **Post date:** [December 2, 2009, 4:25pm UTC](https://forum.liquibase.org/t/creating-packages-and-packages-bodies-with-the-same-file/372/3 "2009-12-02T16:25:00Z")
What version of liquibase are you using?  1.9 or something else? Nathan ---
**Author:** ![svaret](https://avatars.discourse-cdn.com/v4/letter/s/9de053/32.png) [@svaret](https://forum.liquibase.org/u/svaret)\ **Post date:** [December 2, 2009, 4:25pm UTC](https://forum.liquibase.org/t/creating-packages-and-packages-bodies-with-the-same-file/372/4 "2009-12-02T16:25:00Z")
Hi, I have exactly the same problem. We run on 1.9.5 Best regards /Lasse ---
**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\ **Post date:** [December 2, 2009, 4:25pm UTC](https://forum.liquibase.org/t/creating-packages-and-packages-bodies-with-the-same-file/372/5 "2009-12-02T16:25:00Z")
Thanks, I’ll look into it. Nathan ---
**Author:** ![bwperez](https://avatars.discourse-cdn.com/v4/letter/b/9f8e36/32.png) [@bwperez](https://forum.liquibase.org/u/bwperez)\ **Post date:** [December 2, 2009, 4:25pm UTC](https://forum.liquibase.org/t/creating-packages-and-packages-bodies-with-the-same-file/372/6 "2009-12-02T16:25:00Z")
Any chance there is a solution to the delimiter issue?  I am having the same problem in 1.9.0 and 1.9.5.  We store packages, procedures, triggers and other “create or replace” objects in a standard sql file.  Liquibase is used to apply these files using sqlFile but the delimiter does not work.   file: prc.name create or replace procedure prcname as begin null; end; / liquibase changelog \ If there is a “/” at the end of the .sql script liquibase appends an additional “/” to the proc and it ends up invalid.  I’ve tried setting different endDelimiter values but nothing seems to be recongized.  The only way to get it to work is to edit all the .sql files and remove the / from the end of the script. added:  we are using liquibase with an Oracle database. Brian ---
**Author:** ![jfrapper](https://avatars.discourse-cdn.com/v4/letter/j/f14d63/32.png) [@jfrapper](https://forum.liquibase.org/u/jfrapper)\ **Post date:** [December 2, 2009, 4:25pm UTC](https://forum.liquibase.org/t/creating-packages-and-packages-bodies-with-the-same-file/372/7 "2009-12-02T16:25:00Z")
Nathan, Was a solution to this ever posted?  I have the same need for some oracle scripts as well. Cheers, JF ---
**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\ **Post date:** [December 2, 2009, 4:25pm UTC](https://forum.liquibase.org/t/creating-packages-and-packages-bodies-with-the-same-file/372/8 "2009-12-02T16:25:00Z")
I fixed some bugs with how the delimiters were being used, but it is in 2.0.  Could you test out the latest RC and see if that works for you? Nathan ---
**Author:** ![jfrapper](https://avatars.discourse-cdn.com/v4/letter/j/f14d63/32.png) [@jfrapper](https://forum.liquibase.org/u/jfrapper)\ **Post date:** [December 2, 2009, 4:25pm UTC](https://forum.liquibase.org/t/creating-packages-and-packages-bodies-with-the-same-file/372/9 "2009-12-02T16:25:00Z")
> _Originally posted by: Nathan_ > I fixed some bugs with how the delimiters were being used, but it is in 2.0.  Could you test out the latest RC and see if that works for you? > > Nathan It doesnt seem to be in the maven repository, what should I put in for:           org.liquibase           liquibase-plugin           1.9.5.0 Cheers, JF ---
**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\ **Post date:** [December 2, 2009, 4:25pm UTC](https://forum.liquibase.org/t/creating-packages-and-packages-bodies-with-the-same-file/372/10 "2009-12-02T16:25:00Z")
org.liquibase liquibase-maven-plugin 2.0-rc5 The artificatId changed, and the version is now 2.0-rc5 as the newest Nathan