all groups > sql server reporting services > march 2005 >
You're in the

sql server reporting services

group:

Reporting Services with Oracle 8i


Reporting Services with Oracle 8i Harold
3/9/2005 3:33:03 PM
sql server reporting services: I want to know if Reporting Services has problems connecting with Oracle 8i
functions (no procedures), also if it has problems with output parameters in
Oracle procedures and functions.

Re: Reporting Services with Oracle 8i Bruce L-C [MVP]
3/10/2005 8:21:46 AM
Oracle has a variety of things you have to be careful about. I suggest
looking at some of the back posts:
http://groups-beta.google.com/group/microsoft.public.sqlserver.reportingsvcs/search?group=microsoft.public.sqlserver.reportingsvcs&q=Oracle&qt_g=1

RS does have problems with output parameters (not just Oracle, but SQL
Server too). I.e. it does not work with them. When I use stored procedures
in either Sybase or SQL Server I have the last statement in the procedure be
a select statement. RS only works with on resultset from a stored procedure.

I am not even sure if it works with functions or not.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button