> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, June 15, 2001 3:49 AM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: AW: Help with semi colons and Oracle blocks through dbi
>
>
> Somthing like
>
> my $block_count = 0;
> while() {
>
Re the recent email about using bind_columns because it's more efficient:
I was going to ask why binding would be more efficient, then I RdTFM and
realized that the person was talking about binding OUTPUT, not input, and
now I've learned something new, so thank you.
The cheetah book says that bi
I created a simple module that looks up Oracle passwords in a centralized
location so that I don't have to have the password explicitly written in
every piece of code I write. Now, as usual, I'm planning on ruining the
module by making it much more complicated. In particular, I'm planning on
cachi
> > I'm planning on inheriting from DBI::db.
> >
> > My question is, is it safe to inherit from DBI::db?
>
> From: Mitch Helle-Morrissey [mailto:[EMAIL PROTECTED]]
>
> Look at the subclass.t test file that comes with the DBI
> distribution. In
> short, you'll need to inherit from all three DBI
So even though my scripts are paradigms of well-written code, they die
sometimes. When that happens, I want to clean up my DBI stuff nicely.
Generally, the way I do it is:
my $SUCCESS;
# Init stuff snipped
my $dbh = DBI->connect(...) or die $DBH::errstr;
# DBI stuff snipped
$dbh->disconnect or di
Hi.
I understand that DBI::err is very transient. My question is, is it going to
get overwritten in between the different calls in selectcol_array?
That is, I'm doing:
my $arrayref = $dbh->selectcol_arrayref($statement, undef, @bind)
or die($dbh->errstr());
my @arr = @$arrayref;