Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Monday, June 27, 2016 6:38 AM
Points: 159, Visits: 556
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: Monday, June 27, 2016 6:38 AM
Points: 159, Visits: 556
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,065, 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
Posted Thursday, September 10, 2015 7:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, September 11, 2015 7:09 PM
Points: 1, Visits: 6
Hi,
Can I have sample procedure for how to use ref cursor in return from procedure , am bit struggling to access the record from oracle proc thru SSRS. thanks n advance.
Post #1718387
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse