Alas another SQLPlus specific command. The DBMS actually has no way to provide logging output to JDBC, its just not specified in the drivers (Either the standard drivers or using the Oracle specific output). I've tried to get this working in the last month or two for one of my clients and I gave up, its just impossible to get hold of it.
The only workaround I have used to achieve a similar thing is to create a logging table, insert the output into that table and then select (then delete) it. Its an ugly workaround but it gets you the necessary critical information. In my opinion (helf strongly from a position of ignorance on your situation) using logging is a crutch of the old way of migrating databases where you need to see the output to confirm it worked. Liquibase fails and rolls back if it doesn't work and gives you an ugly error. Its a different approach for sure but a reliable one. Paul K ----- Original Message ---- From: "Starr, Thomas" <tst...@cobaltgroup.com> To: liquibase-user@lists.sourceforge.net Sent: Tuesday, 3 February, 2009 22:52:44 Subject: [Liquibase-user] DBMS_OUTPUT?? Thanks Nathan and Paul for the level-set on (not) using @!! Actually I now sqlFile working great for a table, indexes, a trigger, a view, an mv and a package so who needs it :) But how to see DBMS_OUTPUT.PUTL_LINE output? It doesn't even show up with logLevel="finest" Thanks again!! --Tom ------------------------------------------------------------------------------ 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
