how to call a oracle function in ssrs dataset
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
July 10th, 2012 9:00pm

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 :)
Free Windows Admin Tool Kit Click here and download it now
July 11th, 2012 4:32am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics