I don't have Oracle - for which I'm pretty glad, if I'm honest - but with SQL Server, I'd suspect the problem is that you aren't using the query string - you don;t show in your code that the
cmd
object is connected to the
query
object, just that the parameter values are set.
No query in Oracle would seem to generate a "missing expression" error:
ORA-00936: missing expression | TekStream[
^] so I'd start there.