I have tried a few return options and below is what worked for me:

1) return as a ref cursor

2) read oracle procedure from ssrs just like you read a sql server procedure.

Thanks and Regards,

Praveena