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