Oracle database connection in drupal 7
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