Top "Dbi" questions

Why does Perl's DBI complain about "failed: ERROR OCIEnvNlsCreate" when I try to connect to Oracle 11g?

I am getting the following error connecting to an Oracle 11g database using a simple Perl script: failed: ERROR OCIEnvNlsCreate. …

perl oracle dbi

When to use $sth->fetchrow_hashref, $sth->fetchrow_arrayref and $sth->fetchrow_array?

I know that: $sth->fetchrow_hashref returns a hashref of the fetched row from database, $sth->fetchrow_arrayref …

perl dbi

Error handling on DBI->connect

Besides handling error using standard code die "Unable to connect: $DBI::errstr\n" is it possible to write a custom …

perl dbi

Perl DBI - Capturing errors

What's the best way of capturing any DBI errors in Perl? For example if an insert fails because there were …

perl exception error-handling dbi

How to Install DBD::Oracle in Strawberry Perl

I am trying to install DBD::Oracle using the CPAN shell in Strawberry Perl. I initially experienced an error because …

perl oracle dbi strawberry-perl dbd

Fetch data with one row and one column from table using Perl DBI

I am trying to fetch data like (Select 1 from table) which returns data with one row and one column. I …

perl dbi

Why does DBI's do method return "0E0" if zero rows were affected?

I ran into a problem when running code similar to the following example: my $rows = $dbh->do('UPDATE table …

perl dbi

Why can't DBD::SQLite insert into a database through my Perl CGI script?

I am running a SQLite database within a Perl CGI script which is being accessed by DBD::SQLite. This is …

perl apache sqlite dbi

disk I/O error with SQLite

I have a (tiny) dynamic website that is (roughly) a Perl CGI script using a SQLite database. Package DBI is …

perl sqlite cgi dbi

Perl Module Method Calls: Can't call method "X" on an undefined value at ${SOMEFILE} line ${SOMELINE}

All over the place, especially in DBI, I see this message come up all the time. It's confusing, because the …

perl function module dbi