Accessing pl/sql procedure from an SSRS report

  • venus.pvr

    SSCarpal Tunnel

    Points: 4813

    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

  • venus.pvr

    SSCarpal Tunnel

    Points: 4813

    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

  • PaulB-TheOneAndOnly

    SSC Guru

    Points: 66773

    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.
  • dkannanit

    SSC Journeyman

    Points: 81

    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 4 (of 4 total)

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