User Profile

Collapse

Profile Sidebar

Collapse
kgp4death
kgp4death
Last Activity: Jun 28 '14, 12:33 PM
Joined: Jun 28 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • kgp4death
    replied to in and out oracle parameters in vb.net result in null errors
    in Oracle
    crap so i guess it does look for order asnd the output does need to be at end like this.....this works solved my own problem

    Code:
                For Each kvp As KeyValuePair(Of String, String) In sqlParams
                Dim newParam As New OracleParameter(kvp.Key, OracleDbType.Varchar2, kvp.Value, Data.ParameterDirection.Input)
                newParam.Size = 400
                cmd.Parameters.Add(newParam)
    ...
    See more | Go to post

      Leave a comment:

    • kgp4death
      started a topic in and out oracle parameters in vb.net result in null errors
      in Oracle

      in and out oracle parameters in vb.net result in null errors

      so this code works with just the out parameter but then when you add in parameters weird nulls start showing up and also the straight in parameters work too so it is just when there are both in and out parameters. and i have tried the out parameter at end and beginning of parameter list

      the part with problems is the in and out parameters do not want to coexist
      Code:
                  cmd.Parameters.Add("PKEY", OracleDbType.Int64,
      ...
      See more | Go to post
      No activity results to display
      Show More
      Working...