June 14, 2017 at 2:56 pm
hi,
Am using oracle DB for getting the data, usually my query is executing less than 3 minutes in SQL developer for 50,000 rows. But when i try to run SSRS report with same query am not able to see the report output "Keep on saying LOADING". Here I have to tell one thing am trying to bind a CLOB data to a ssrs table, which means there is more number of characters for each record.
Please help me how to resolve this issue.
Much appreciated if anyone provide a solution.
Many thanks.
Regards,
Venkatesh
June 15, 2017 at 10:31 am
You're accessing data in very different ways when comparing SQL Developer and SSRS so that comparison really doesn't matter.
Are you using the built in provider, extension for Oracle? If so, please refer to the documentation where it says:
The data processing extension OLE DB for Oracle does not support the following Oracle data types: BLOB, CLOB, NCLOB, BFILE, UROWID.
The documentation can be found here:
Data Sources Supported by Reporting Services
Sue
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply