Running Oracle query as script | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Running Oracle query as script

My report needs to query an oracle database. The query is actuall a series of sql commands. When I run this in reporting services I get an error due to the semicolons seperating the sql commands. Is there any way to run this query as a script so that reporting services doesn’t choke on the semicolons? Running it as a stored procedure is not an option as I’m unable to attain the permissions needed to do this from the dba. -Aaron