sql server reporting services: Hello,

How can i use and define parameters in an query using oracle database ?
When i try to use =@param, the system make an automatic transformation to
='@param'.

Thanks for the answer,

Benoit

The managed Oracle data provider uses a ':' to mark named parameters; the
OleDB provider for Oracle only allows unnamed parameters (using '?'). The
following KB article explains more details:
http://support.microsoft.com/default.aspx?scid=kb;en-us;834305

Note: the Visual Data Tools (VDT) query designer (2 panes) actually uses OLE
DB in the preview pane. The text-based generic query designer (GQD; 4 panes)
uses the .NET provider for Oracle. Whenever you get strange results in VDT,
you should try it with GQD.

Examples for parameterized queries:
Managed Oracle provider (named parameters):
select * from table where ename = :parameter
OleDB for Oracle (unnamed parameters):
select * from table where ename = ?

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]