I don't have Oracle, so I can't exactly give you an example. However, when you add a data source for SQL Reporting Services, the first tab is provider, so you should be able to select any available provider as long as your server also has that provider installed.
That should include Oracle. I know it includes IBM's AS/400 driver.