venus.pvr (12/14/2011)
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
Thank you for the feedback Praveena - that will help other SSC members.
By the way, you are corrrect - a PL/SQL storedproc will always return a ref cursor.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.