Apache, DBI, Oracle

From: Kevin Moore (kmoore_at_esntech.com)
Date: 06/16/04 

Date: Wed, 16 Jun 2004 12:00:32 -0700
To:  dbi-users@perl.org

Experts,

Does anyone have a step by step procedure for configuring apache,
mod_perl, and DBI for accessing an oracle database they'd be willing to
share?

I've got Oracle and a simple perl script using dbi to extract data from
a database running from the command line but am receiving "server Error"
when running the same script from the browser so I know the DBI modules
are communicating with the database. I'm not an expert in this area and
am just not finding anything comprehensive enough to make this work
through Apache. The database and webserver are on different linux servers.

Thanks.

Kevin

Relevant Pages

  • Re: Accessing oracle from windows 2000
    ... I am _NOT_ a windows expert, but I am on a Windows XP machine ... and I have gotten DBI to connect to an oracle database using DBD::ODBC. ...
    (perl.dbi.users)
  • RE: fetchrow_array performance
    ... I agree - set RasieError. ... it is impossible to tell what is going on in the database without a 10046 trace. ... You aren't error checking your dbi statements - do you have RaiseError ... sender of the delivery error by replying to this message, or notify us by ...
    (perl.dbi.users)
  • Re: Evaluated "require $database" not found.
    ... DBI Error 1046: No database selected ... What I have found is that if the spaceare removed as per the correct syntax, then the DBI_errorhandler will trap and report a connection failure if a non-existent database is specified, as per this example: ... This requires that you first have an installation of mysql setup on a host ...
    (perl.dbi.users)
  • Re: Cant call method "prepare" on an undefined value
    ... Somehow you managed to have an undefined value instead of a DBI database handle in front of ->prepare, which is burried deep inside Oraperl.pm. ... Oracle HTTP Server at Server B. Both server are Solaris server. ... I have installed DBI and DBD into Server B and setup the oraperl in my perl script. ...
    (perl.dbi.users)
  • Balasan: RE: Balasan: RE: Balasan: RE: Balasan: RE: cant execute "use $database"
    ... dictionary of the each database of my MSSQL. ... to load it -- DBI will load it for you. ... Subject: Balasan: RE: Balasan: RE: Balasan: RE: ...
    (perl.dbi.users)