Hi,

I'm looking into using Drupal as the CMS for our website and would be very grateful if anybody could tell me how you run queries on an Oracle database? I know very little about this, so apologies if I'm asking anything very obvious!

Part of our current website is hosted on a different server and generates pages from an Oracle 10g Database, currently running on Oracle Application Server 10g, but about to move to Tomcat on Apache.

We would like to be able to query this database from the content managed website. Are there any Drupal modules that simplify this process? Or do queries have to be coded in PHP?

Any advice on this would be very much appreciated.

Cheers

Comments

aitala’s picture

I think Drupal 7 is working on supporting Oracle...

You might want to check http://groups.drupal.org/enterprise and http://www.oracle.com/technology/pub/articles/pedros-drupal.html

Eric

__________

Eric Aitala - f1m@f1m.com
The Formula 1 Modeling Website
www.f1m.com

__________
Eric Aitala - ema13@psu.edu
Penn State

224b8605113373e086cb27708ff301ba18ce394db1996e7e22928e4555e0d20b1b6cecc7f67c9bd9e536cb915779c485

BTOweb’s picture

Thanks Eric, I'll check these out.

Cheers
Laura

aaaristo’s picture

You can download an unoffical 6.x driver from here http://sourceforge.net/project/showfiles.php?group_id=240224
It does not touch the core code, and works with cck, views, and other modules.
Works with any 6.x.

hope this helps.