Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2008

    Unanswered: Problems with Oracle Parameter


    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.


  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1

    While somewhere down stream Oracle RDBMS may get involved, this appears to be some sort of generic programming problem (Java?).

    I suggest posting to a different & more appropriate forum.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts