Oracle Parameter not getting value

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Probi
    New Member
    • Apr 2008
    • 5

    Oracle Parameter not getting value

    Hello,

    I have this parameter

    OracleParameter p1 = new OracleParameter ("p1", OracleType.VarC har, 8);
    p1.Direction = ParameterDirect ion.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
Working...