VS2022 and SSRS – Problem with parameter and Oracle database

Question

here is my request

select * from users a WHERE trunc(A.registered) between to_date(@Date,'dd/mm/yyyy') and to_date(@Datee,'dd/mm/yyyy') ORDER BY a.name

@Date and @Datee are the parameters I created; i use an oracle db

when i put my request in my dataset and when i refresh the fields i get the error ERROR[HY000][Oracle][ODBC][Ora]ORA-00936: missing expression and my report does not run.

on the other hand when I delete the where clause I receive no error and my report runs normally

the conclusion is that my problem is certainly at the level of the where clause. however at first sight I do not see the error

can you help me?

Answer 1

Hi @user

In SSRS with an Oracle OLEDB connection, if you want to use parameters, you need to use a colon, not the @ sign.

For more details, you can refer to this link: parameter in sql query :SSRS.

Best regards,

Aniya

Answer 2

I found the solution

• with oracle you must use the character : concerning the parameters
• you must not use the parameter name DATE which is protected by oracle