Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Accessing pl/sql procedure from an SSRS report Expand / Collapse
Author
Message
Posted Tuesday, December 13, 2011 11:11 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:38 AM
Points: 125, Visits: 455
Hello,

In order to access and run pl/sql procedure from an SSRS report:
1) Which format should the pl/sql procedure return the data in?
2) How do I read the data returned from SSRS?

I haven't found any resources on the internet. Please give references if you know of anything that will guide

Thanks and Regards,
Praveena
Post #1221074
Posted Wednesday, December 14, 2011 3:19 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 9:38 AM
Points: 125, Visits: 455
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
Post #1222092
Posted Thursday, December 15, 2011 6:27 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
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.
Post #1222368
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse