Hi guy,
I'm creating SSRS reports which get data from Oracle database by ODBC. Using Dataset properties, I can define query and want to use parameter in it. After research, I can you ":" to pass parameter. For example:
SELECT SNAPSHOT_DATE
FROM SBV_SUMMARY
WHERE 1= :pParam
Can you give me which is best practice to using parameter with Oracle by ODBC as discribed. Using ":" or something else better?
Thanks so much.
