Oracle database connection in drupal 7 I want to retrieve a list of products from an external oracle database and show it in my drupal site as a catalog.
But the problem is that, how can I make the connection to oracle db from a drupal 7 site.
Please any suggestion on how to perform this operation is highly welcome.
Thanks!
I recommend separate this from Drupal. I mean if you just want a list of products so write an external application to prepare a xml format of this list and feed it to Drupal.

You need install PHP PDO_OCI to make connection from PHP application into Oracle. 

Drupal has an Oracle Driver but I recommend external application instead