Oracle Parameter not getting value

Question

Hello I have this parameter OracleParameter p1 = new OracleParameter(p1 OracleType.VarChar 8); p1.Direction = ParameterDirection.InputOutput; and I have a string ( ex. string val = ABCD) to add to the parameter I use the line : p1.Value = val; and in the debugger I see that val has the ABCD value but p1 has only AB I tried with strings with different length and it aways passes the first half of the characters ( val.length div 2) any ideas what is wrong and how to fix it? I use this line in other code too and it makes no problems. Thanks Probi

John Penn · Answer

Don't use both calls. ExecuteReader() is for SELECT statements. ExecuteNonQuery() is for UPDATEs DELETEs and INSERTs. When you call both you are executing the same SQL code twice for no reason. This is very inefficient and will make your code run slower than it needs to. Remove the ExecuteNonQuery() call and see what happens.

Probi Forumi · Answer

the command is string cmd2 = Select Iteration_Name from Iterations where Project =:p2 ; OracleCommand command2 = new OracleCommand (cmd2 connection); OracleParameter p2 = new OracleParameter ( p2  OracleType .VarChar  8); in other code I have used ExecuteNonQuery() and ExecuteReader() in that order and it showed no problem... I can not figure out why here it cuts the string thanks Probi

John Penn · Answer

Why are you calling ExecuteNonQuery() and ExecuteReader() on the same Command object? It should be one or the other... Can you post the source code for the SQL code being called?

Probi Forumi · Answer

This is what I see when I put the breakpoints p1.Value = val ( p1 = ABCD) command1.ExecuteNonQuery(); (p1 = AB) rdr1 = command1.ExecuteReader(); (p1 = A) while (rdr1.Read()) { do something } (p1=) why is this happening? thanks Probi

John Penn · Answer

Is the truncation occuring before the database call or afterwards?