OracleCommand parameters on CHAR type columns

Question

I am using OracleCommand.Parameters in a select query for on an Oracle 11g database. The following statement works great on columns that are of type number or varchar.

string theQuery = "select * from TABLE where COLUMN = :p1";
OracleCommand Cmd = new OracleCommand(theQuery);
Cmd.Parameters.Add(new OracleParameter("p1", "2183989118"));
Cmd.Connection = Conn;
Cmd.CommandType = CommandType.Text;

The problem is that I really want to run the statement against a column of type CHAR(20 BYTE), and when I do this i never get a result. The query works if I am not using parameters and just adding '2183989118' in theQuery directly.

Am i missing something in my Parameters.Add statement?

Are you sure there is no " 2183989118" value in COLUMN. new OracleParameter("p1",OracleDbType.Char); — baklarz2048
– baklarz2048, Commented Aug 24, 2012 at 7:42

Robert · Accepted Answer · 2012-08-24 07:42:48Z

1

Try this

  Cmd.Parameters.Add("p1", OracleDbType.Char);

answered Aug 24, 2012 at 7:42

Robert

25.8k8 gold badges70 silver badges86 bronze badges

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

1 Comment

Henkealg Over a year ago

I ended up editing the Parameter like this: Cmd.Parameters.Add("p1", OracleDbType.Char).Value = "2183989118"; Working great, thanks!

Collectives™ on Stack Overflow

OracleCommand parameters on CHAR type columns

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related