Webmaster Forum / Perl / DBI Library / February 2006

I just install DBD::ORACLE in PERL, and try to connect to my ORACLE DB.
However, I receive the following error message. Does anyone know how to
resolve this problem? Thanks
"The procedure entry point OCINlsEnvironmentVariableGet could not be located

In the CDBI docs I see an example like this:
my $artist3 = Music::Artist->search( name => 'Polysics' )->first;
but no other mention of 'first'. What's this?
Thanks

So I've dabbled with Class::DBI on past projects, and I'm planning on
using it with a new project that I'm putting together here.  While doing
some additional homework, I came across the Class::DBI::Frozen::301
package on CPAN, started reading, and started getting nervous.  I've

Formulas for great circle distances aren't hard to derive using just
basic trig.  No calculus required!
That being said, the Math::Trig package comes standard with Perl
distributions and has a function called great_circle_distance().  Try

I have a Solaris 8 host running perl 5.8 and using DBI version 1.50 and
DBD::Oracle version 1.16. The database is Oracle 10.2.0.1 and runs on a
different host.
If I run this query from a shell script, it completes in under 1 second,

My sys admin has installed perl::DBI on AIX 5.2 and when I try to load
this in my perl client ..I get a core..
cat test.pl
#!/usr/bin/perl

Hi all. I am co maintaining CDBI::Rel::IsA with Teejay.   I'm
currently working on it to upload a version today.  I'm a month or two
behind but expect that. I have a couple questions.
1) How to Handle  CDBI Frozen vs Not Frozen versions.  I am thinking

Hello out there,
I just try to call a PostgreSQL-function via the DBI.
The function is very simple:
CREATE OR REPLACE FUNCTION neues_suchprofil ( NUMERIC, TEXT ) RETURNS void

Hi list,
 I have installed Spreadsheet::WriteExcel and Parse::RecDescent without any issues, compilation and installation went went but they are not working.
 bash-2.05# perl -MSpreadsheet::WriteExcel
Spreadsheet/WriteExcel.pm did not return a true value.

I'm using Oracle, and after long periods of idle, my database connection is
closed.  Is there a way to ask class::dbi to reconnect?
Thanks
Jay

  I am writing a Web app in perl/cgi/dbi which (1) attempts to verify
logins by checking against database user passwords, and (2) follows good
dbi practices by logging the user in once at the beginning of the session
instead of logging in immediately prior to accessing the database ...

I've got a weird problem - I don't begin to know what's happening and
wonder if anybody has seen anything like this before?
I'm running a script that uses Class::DBI to access a MySQL database.
When I run it after a few minutes it goes into a loop. Up to that point

I am writing a Perl -CGI script and want to dynamically load the
drop-down list using the values retrieved from the database.
I am accepting the values retrieved from the database into the array
and then using it to populate the drop-down. But only the last value

a while back I posted a test script (attached) that showed up a bug in
the object index that means that a new row whose PK comes from a
sequence is not added to the index correctly, although this may only
affect users of postgres. In the thread that followed a solution came

One of my programmers is reporting this. In my heart I believe its got
to be a stupid-perl-typo-that-we-don't-see, but since we both cannot
see it, I submit it to the community at large, with asbestos underwear
firmly in place.