Oracle Parameter not getting value

Probi Forumi

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Guest User18y ago
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 Forumi18y ago
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
Guest User18y ago
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 Forumi18y ago
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
Guest User18y ago
Is the truncation occuring before the database call or afterwards?