Webmaster Forum / Perl / DBI Library / November 2005

I'm migrating my old code to CDBI and I'm having some difficulties
because it's my first experience with CDBI.
I have 2 SQL query which I need to move to CDBI.
1) SELECT a.id, a.name, al.id, al.name, al.cnt_tracks, al.status

Sorry, I know this is off (DBI) topic, but it does relate to Perl and a database.
I'm about to start developing an app with Perl DBI with the thought that eventually I'd like to put the app on the web - for which I plan to get a website hosting company, like Yahoo or whatever.  So ...

There is a problem in Oracle 10.2 that surfaces after you install the latest
Perl, dbd-oracle and dbi on a windows box.  The symptom is that sqlplus and
sqlplusw no longer function, they return almost immediately to the command
prompt.  This is a know but undocumented problem in ...

I could not find some info in the docs. I just want to delete an
object that is instantiated with a hash of two primary keys. I tried
this:
TableClass->retrieve(%pks)->delete;

I am new to DBI, and that may explain my question.
Using DBI::Proxy, I am trying to connect remotely to an Oracle
database whose datasource looks like this:
 'jdbc:oracle:thin:@127.0.0.1:1521:abc'

Hi - I'm soon to be doing a Perl app on the Internet, that'll need
database. We want the db to be as "free" as possible, but still fully
multi-user (web-based). Would the best route be MySql on Linux? Random
access files? Something else? We want no licensing obligations (no Oracle,

I have to load a file of significant size into my Oracle 10g database on a
monthly basis. Things became complicated and I have no other recourse but
to pre-parse file with Perl. For speed sake, I thought of using the array
interface. What I found out shocked me: DBI has array binds ...

 file: $CPAN/authors/id/T/TI/TIMB/DBI-1.49.tar.gz
 size: 385494 bytes
  md5: dd9c7b50d0fbfd04d1737c273cb1b9a5
=head2 Changes in DBI 1.49 (svn rev 2287),   29th November 2005

What is the simplest way to do something like "!=" or greater than in
Class::DBI?
I apoligize for this question.  I swear I have pored over the docs.
Regards,

I am upgrading my Oracle client.  This probably means I need to recompile DBD::Oracle.  Correct?
Thanks,
Ian

My name is Kotra Kiran Kumar .I am working in HSBC Software ,Pune,India .I
installed Http::Recorder perl modules .When I am trying to run
http-recorder I am getting code when I moved from one page to another page
through links.But when I submits any form in the web page the proxy

Dear Sir/Madam,
I am using DBI module in my perl script. And also i am using the grep
utility along with awk. This utility works fine when we are not initialize
the DB connection. If we initialize the DBI connection it throws the error

i have a little problem with Class::DBI.
I think its because one of my tables has no primary key.
I have this two tables:
CREATE TABLE "option"

If I remember properly, I think I saw that error when setting up
Apache::Session::Oracle.  I have my A_SESSION column set up as type
LONG.  I'm running 9iR2.  Hope that helps.
Ted Behling

All of a sudden I'm getting this error on my server.
Please let me know what the cause to this type of error then I can bark
at right tree.
Thanks in advance.  And happy holiday to every body !!!