Webmaster Forum / Perl / DBI Library / April 2006

Has anyone seen this error before and if so would you know the solution
to fixing it?
DBD::ODBC::st execute failed: [unixODBC]Prepared statement not a cursor
specification (SQL-07005)(DBD: describe/SQLDescribeCol err=-1)

Any other repositories anyone knows of where I can download this?
ftp.esoftmatic.com and ppm.activestate.com have both been unreachable all
day. Google has been uncharacteristically unhelpful.
tia,

Maybe this is old news to some, but the
FAQ link and support->details links (any of them)  aren't working on
dbi.perl.org.
Jay

I've been having trouble with my DBD::Oracle on Windows XP SP2 with
ActiveState Perl, so today I removed and installed Perl, DBI, and
DBD::Oracle.  Same problem. Help?!
PPM installed the Oracle Instant Client and concluded:

for example, a table, 2 column
Table
------------------------------------------------------------

I have 2 machines: linux_perl_machine and sql_server (Oracle 9i).
I am trying to connect from the perl machine to the sql_server and execute :
"select Hebrew from Hebrew_Table" ,
but all I get is somthing like: '???? ??????'

I am using DeepAbstractSearch with Class::DBI and I believe I have come
across a bug. When doing a deep search on a column that shares a
relationship with another column
########################################################################

VS:
Depending on your Perl version, you might try http://www.cedet.dk/perl
- it has copies from ftp.esoftmatic.com for AS Perl 5.8.0,2,3,4!
HTH

Hi,  I'm sorry about having to ask such a basic question.
I'm trying to add transactions to my database.  I have been able to
commit insertions and edit records but I really can't work out how to
commit deletions.

I'm working on a project that seems to have painted me into the corner
labeled "needs to use Class::DBI::Relationship::IsA".
Apparently, based on my debugging and then some googling, the version
of C...IsA on CPAN isn't completely compatible with CDBI 3.0.14, which

Hi, I'm rewriting a reasonably big project to use Class::DBI instead of
DBIx::Abstract. How can one get access to sequences in Class::DBI? Given
a sequence in Postgresql, I want to access the current value and the next
value. With DBIx::Abstract I can do:

 I am using DBI Version 1.42 on OSX, accessing a MySQL database on
Linux (Mandrake)
Previously I have been using DBI with mysql on Linux, I always used
        $sth=$dbh->prepare("INSERT INTO ......");

I was wondering (and found nothing bout that on the web), can I use DBI to
execute some oracle DB functions?
Here's my case: I have a (oracle) function that returns a new free ROW ID
randomly and I have to manage that RI from a perl script. Can I use DBI to

Connect_cached has a hidden side-effect (documented in code, but not in
doc) :
  # XXX modifies callers data!
This is annoying when the caller uses Readonly : then connect_cached

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
NotDashEscaped: You need GnuPG to verify this message
I'm getting a lot of warnings when compiling DBD::Pg using Perl 5.8.8