SQL Reporting Services: Using Parameter Queries with Oracle Sources
I came across this today when I tried to create a report in SQL Server Reporting Services against an Oracle database using the Oracle .Net Provider.
Against SQL you can define parameters in the report query using @paramname syntax. This doesn't work against an Oracle database. It took me a while to remember how to define named parameters in PL/SQL (It has been near to 9 years since I've touched PL/SQL) which is :paramname rather than @paramname then everything starts to works again.