Post reply

Accessing pl/sql procedure from an SSRS report

  • December 13, 2011 at 11:11 am

    #247607

    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

  • December 14, 2011 at 3:19 pm

    #1421658

    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

  • December 15, 2011 at 6:27 am

    #1421886

    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.

  • September 10, 2015 at 7:57 am

    #1825671

    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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply