Makarand Kulkarni (makkulka_at_cisco.com) wrote:
: Noira Hadi wrote:
:
: > Hello,
: >
: > I am currently working to get data from Oracle database and publish them
: > to webpage, running on Apache server by using some search strings. I was
: > suggested to use Perl for the job. I browsed some website and newsgroup
: > on getting some info. Appeciate if anyone could advise on the items
: > below:
: > 1) What driver do I need for the job? ( I have installed DBI/DBD on
: > my machine)
:
: DBD::Oracle
[snip]
: Once you have DBI installed and the DBD::Oracle accessing Oracle databases
: is not differnet
: from accessing from any other databases. You can grab any script that
: accesses databases
: using DBI as sample code and make it work.
One thing to beware of: opening a connection to an Oracle database is
*not* particularly fast; if your program logic requires establishing a
connection each time a page is served, things will bog down quickly. If
that's the case, you should look into something like mod-perl of FastCGI
that will allow you to maintain a persistent connection to the database.
Received on Fri Nov 26 1999 - 00:56:17 CST
