If you are looking to reuse files that you could load with the oracle loader, you could use the executeShellCommand tag to make a call to the oracle loader and have it run as it used to. That may or may not be of help to you depending on your setup and what you are trying to accomplish.
Nathan -----Original Message----- From: Paul Keeble [mailto:cs...@yahoo.co.uk] Sent: Tuesday, February 03, 2009 3:42 PM To: liquibase-user@lists.sourceforge.net Subject: Re: [Liquibase-user] Using Oracle @ No it wont work because that isn't valid SQL in any way. It is in fact a sort of pragma to the oracle command line to allow it to import the file in that place and run it. Paul ----- Original Message ---- From: "Starr, Thomas" <tst...@cobaltgroup.com> To: liquibase-user@lists.sourceforge.net Sent: Tuesday, 3 February, 2009 17:18:45 Subject: [Liquibase-user] Using Oracle @ If <sqlFile> references a file that uses the Oracle @ syntax to invoke another file should that work? Using <sqlFile> repeatedly works fine but am trying to reuse existing files. Thanks!! -----Original Message----- From: Starr, Thomas Sent: Monday, February 02, 2009 2:51 PM To: 'liquibase-user@lists.sourceforge.net' Subject: RE: [Liquibase-user] Oracle anonymous blocks and triggers 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 ------------------------------------------------------------------------------ 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 ------------------------------------------------------------------------------ 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
