Webmaster Forum / Perl / DBI Library / September 2006

I've been dealing with this issue for some time now, and finally
had the time to narrow down the cause, tho I don't know what
the solution is...I'm hoping someone might have some light
to shed.

Hello DBI-users,
After some requests, I've uploaded an Oracle Troubleshooter HOWTO to my
homepage, that should help you if you get "Can't load Oracle.DLL" and
similar errors with DBD::Oracle.

Is it possible to connect to an MS access database on windows from a
linux machine using DBD::ODBC without needing unixODBC?  Would I need to
first set up a system DSN on the windows machine or according to the
DBD::ODBC documentation can I connect without a 'full' DSN, whatever

I've a several 100 thousand line application.  I did not introduce this issue, but I need to fix it.
prepare_cached(SELECT  foo FROM A where X = ?)
statement handle MyDBI::st=HASH(0xd630194) was still active at X.pm
I've tried turning on $dbh->(12, 'file.trace') and looking for all ...

I installed DBI and everything worked. Now I am trying to install
DBD::Oracle 1.18a on a unix box which has Oracle 10 client and gcc. perl
MakeFile.PL worked fine. But make is giving this error after mentioning
about a string of syntax errors.

In my project I first prepare an INSERT statement 'INSERT INTO table
(col1, col2, col3, ...) VALUES (?, ?, ?, ...)' once, then insert
multiple records using 'execute(@values)'. The problem is that not all
values of all columns are available. So I should either leave them empty

Is it possible to pass an array as a parameter into an Oracle Stored
procedure.  I am using Oracle 1.18a.
I have looked all over the place and have not found anything that states
that this is possible.

Hello,
I have this script under, it doesn't work.
I have installed the module DBD-Oracle on my Windows platform, I have a Oracle client who's working in SQLplus mode.
Please help me, to configure my platform or my perl module to work with Oracle with a Windows Platform.

For your reference:
sub dump_results {      # also aliased as a method in DBD::_::st
   my ($sth, $maxlen, $lsep, $fsep, $fh) = @_;
   return 0 unless $sth;

The DBI module when connecting to a mysql database seams to only support
integer values for the mysql_connect_timeout if you use say 0.5 secs as the
timeout value it defaults to 3secs. Does anyone know a way round this
problem as i need a very short timeout in my application.

My system is running an Oracle10G server with PERL DBI, whenever I run
the perl scripts with DBD connect, there will be an Oracle sub-process
with parent ID of 1.  Normally, the sub-process should have a parent ID
= pid of the perl script.  Running any other scripts with SQL*PLUS is

I was wondering if anyone has written something to trace stored
procedure execution.  For example I have a stored procedure sp1, which
needs to run another sp2 to get some data it needs, etc
thanks!

How do I know that $foo->delete actually deletes the object in the
database?
   my $foo = Foo->retrieve($id);
   # some other session deletes the row from the database

I am looking for a tutorial or "how to" which explain how to connect to
Oracle RAC. I have connected to simple Database but here I don't know what
is the host name sid etc'
could you please  refere me where to start?

All,
To set a context for this email, I will remind you, or tell you for
the first time if you hadn't already heard it, that the current plans
for my Rosetta RDBMS have it being written in Perl 6 only due to that