Are there any caveats or known issues with using a materialized view through the Oracle data provider/processing extension in SSRS? I assume that this is all handled server-side and that it shouldn't affect report design or execution but just wanted to double-check. Paul Turley [Hitachi Consulting] SQLServerBIBlog.com

Hi Paul, I am not sure if there are known issue but I've just came across pretty unknown one. The problem seems to be related with 00-600 Oracle error. Report run correctly in BIDS but it throws error when run on SSRS server. Can I ask if you have found any known issues since you asked that question? Thanks in advance Jacob