Webmaster Forum / Perl / DBI Library / July 2008

The Oracle::OCI module provides access to the entire Oracle OCI
interface. Every feature Oracle offers can be accessed via OCI.
Including Transparent Application Failover (TAF) and bulk loading.
The Oracle::OCI module bootstraps itself at build time. Automatically

"Martin Evans" <martin.evans@easysoft.com>, "dbi-users" <dbi-users@perl.org>
unsubscibi me plz - unsubsicrib mi please  <unsubscribe-dbi-users@perl.org> how to

I am in the process of moving some select SQL which was in Perl into
functions and procedures in an oracle package which return a cursor the
perl can read i.e., to hide the SQL from outside the database. Some of
these select statements read clobs.

Hi Tim
I read your post on http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/index.htm. Thank you for the great information.
I was using korn shell for years.
few things I do not see there is:

Is it possible to retrieve the associated parent db handle from a statement
handle? I am subclassing DBI and am overriding a few statement methods, and
in those statement methods I would like to store information in the db
handle (as shown in the docs with ...

So I've been tracing this extremely weird segfault in my code for
about half a year now mostly due to the evasive nature of the crash
and finally traced it down to these specific steps:
- perl 5.10 (happened in 5.8 too)

I'm looking for a *portable* way to detect auto-incrementing primary
keys. Is there one?
I'm using $dbh->primary_key_info to fetch details about column(s) that
are participating in primary keys, but this doesn't mention whether

With RaiseError or PrintError set, if DBD::Sybase throws an error, the
error message does not indicate what line number of the program that the
error was on ... or what program/module that the error was in.
DBD::Oracle and DBD::ODBC both have program/module line numbers at the

Hey, all I have a db in production that uses a whole lot of string  
values as primary keys. (It's Oracle, FWIW)  Does DBIX::Class care  
what data type a primary key is?  I *vaguely* remember hearing some  
sort of remark in the Catalyst master class Jon Rockway taught at YAPC