This content has been marked as final. Show 2 replies
Did you try using # instead of : for the bind variable?
have a look here: http://stackoverflow.com/questions/6898611/what-is-the-sql-server-equivalent-of-oracle-bind-variables-in-dynamic-sql
Seems the SQL server bind variables are set different from Oracle. Alternatively you may want to use the standard SQL