Re: How to call DBD::Oracle's dbms_output_get from within a DBIx

On Thu, Feb 22, 2007 at 09:13:15AM -0500, Garrett, Philip (MAN-Corporate) wrote:
Tim Bunce wrote:

You need to either use a separate non-DBIx::Log4perl dbh for the
dbms_output_get call, or try something more hackish like

my @d = $dbh->func('dbms_output_get')
unless $sth->{Statement} =~ /^begin dbms_output.get_line/;

A slightly more efficient (maybe less hackish? ;-) way would be to use a
localized package variable as a semaphore:

Much better, yes. Thanks.

Tim.
.