SQL Server Performance

Running Oracle query as script

Discussion in 'SQL Server Reporting Services' started by Aaron Levin, Mar 24, 2004.

  1. Aaron Levin New Member

    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

Share This Page