Oracle Database Discussions

Hi,

I am connected to our Oracle Data Source in our company using Report Builder 3.0 (Og god it killed me till it has got connected)

Connection is fine and bringing even Fields from the Database when i run it in query designer.

It runs also perfectly when my query is like

SELECT * FROM Materials where project_no like '235800'


I want to add a parameter which I have done it many times using Microsoft SQL Data Sources anf works fine but in Oracle it returns an error like ORA-01036: illegal variable name/number\n

The new Qery is:

SELECT * FROM PDMS_MTO_PIP where project_no like @PROJECT_NO

And of course I have added a Parametes in the Data Set properties and also in the report Data.

Any idea why is that?

Thanks in advance for helps.