Thanks Damian!! Adding splitStatements="false" as you suggested works both when executing an anonymous block using <sql> and when creating a trigger using <sqlFile>.
Cheers, Tom -----Original Message----- From: Damian Gołda [mailto:damian.go...@gmail.com] Sent: Friday, January 30, 2009 1:38 PM To: liquibase-user@lists.sourceforge.net Subject: Re: [Liquibase-user] Oracle anonymous blocks and triggers Hi I suppose the reason s that sql and sqlFile split whole text to many statements using ";" as delimiter. So try: - set splitStatements attribute to false, or - use createProcedure element (yes, I used createProcedure for plsql functions and packages). -- Damian 2009/1/30 Starr, Thomas <tst...@cobaltgroup.com>: > Hi folks - I need to confirm whether one should be able to use either update > or updateSQL where <sqlFile=> in the change log references a file containing > anonymous plsql block (or a trigger). > > > > Also whether update and updateSQL should both work with the same anonymous > block (or trigger) instead enclosed in <sql></sql> tags in the change log. > ------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ Liquibase-user mailing list Liquibase-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/liquibase-user ------------------------------------------------------------------------------ Create and Deploy Rich Internet Apps outside the browser with Adobe(R)AIR(TM) software. With Adobe AIR, Ajax developers can use existing skills and code to build responsive, highly engaging applications that combine the power of local resources and data with the reach of the web. Download the Adobe AIR SDK and Ajax docs to start building applications today-http://p.sf.net/sfu/adobe-com _______________________________________________ Liquibase-user mailing list Liquibase-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/liquibase-user