Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//ictdbs36.ad.ic.ac.uk:1545/ICPRJ04", "APPS", "asdasdasd");

                conn.setAutoCommit (false);

 

                Statement stmt = conn.createStatement();

 

                DbmsOutput dbo = new DbmsOutput( conn );

 

                dbo.enable( 1000000 );

 

                stmt.execute( stmtSTR );

                stmt.close();

 

                dbo.show();

 

                dbo.close();

                conn.close();