Error "ORA-00933: SQL command not properly ended" on Select with ODBC Command
From my experience, I have noticed several instances where a semicolon will break the query, such as JasperSoft Studio and the cx_Oracle Python module. I know very little about ODBC vs OracleDataClient, but I would imagine this is a similar situation.
I would not use ODBC I would actually do something like this using the OracleDataClient
var strSQL = "SELECT * FROM TABLE(SCHEMA.PKG.SPNAME('PARAMS'));";using (OracleConnection connStr = new OracleConnection(connectionString)){ using (OracleCommand cmd = new OracleCommand(strSQL, connStr)) { cmd.CommandType = CommandType.Text; cmd.Connection.Open(); cmd.ExecuteScalar(); //change the ExecuteScalar to fit the proper call }}