locked
how to call a oracle function in ssrs dataset RRS feed

  • Question

  • This is the query I am running in oracle

    select * from table(FUNCTION_NAME(524,'yz'));

    How can I do this is ssrs dataset


    Plz mark as Answer if your problem is resolved. Reddy

    Wednesday, July 11, 2012 1:00 AM

Answers

  • Hey There,

    The important thing that you need here is an ORACLE driver / OLEDB /ODBC to connect to your data source. You would then be able to run the SQL written for ORACLE from within your SSRS report. (I am unsure if you have done this step and need any further help)

    Below is an MSDN article that talks about accessing and issuing queries to an ORACLE data source from within SSRS:

    http://msdn.microsoft.com/en-us/library/dd220591%28v=sql.100%29.aspx

    Below is a link to an article that talks about installing / configuring the ORACLE drivers for use within SSRS (download the whitepaper from the link):

    http://www.robkerr.com/2010/03/oracle-driver-configuration-for-ssis.html

    Let me know if you need any further info.

    HTH.

    Cheers,

    IceQB


    Please mark correct answers :)



    Wednesday, July 11, 2012 8:32 AM