Oracle.DataAccess.Client.OracleException: ORA-00936: missing expression

Question

I wrote a C# console program to try to query some data from Oracle, it is a very simple query but I don't know why it is always tell me "missing expression" while running it, see below my code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Oracle.DataAccess.Client;
using System.Configuration;

namespace ConnectToOracle
{
    class Program
    {
        static void Main(string[] args)
        {

            string strCon = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

            using (OracleConnection oc = new OracleConnection(strCon))
            {
                OracleCommand cmd = new OracleCommand("select dname from dept where deptno = @deptno", oc);
                OracleParameter op = new OracleParameter();
                op.ParameterName = "@deptno";
                op.OracleDbType = OracleDbType.Int32;
                op.Direction = System.Data.ParameterDirection.Input;

                cmd.Parameters.Add(op);
                oc.Open();
                string dname = (string)cmd.ExecuteScalar();
           }
        }
    }
}

so, at the last line, the error "missing expression" will be thrown from cmd.ExecuteScalar() method, can any one tell me why? I was confused

thanks in advance!

atokpas · Accepted Answer · 2016-11-04 06:29:43Z

13

Use : instead of @.

 OracleCommand cmd = new OracleCommand("select dname from dept where deptno = :deptno", oc);
                OracleParameter op = new OracleParameter();
                op.ParameterName = "deptno";
                op.OracleDbType = OracleDbType.Int32;
                op.Direction = System.Data.ParameterDirection.Input;

Reference:OracleCommand.Parameters Property

answered Nov 4, 2016 at 6:29

atokpas

3,3571 gold badge13 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle.DataAccess.Client.OracleException: ORA-00936: missing expression

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related