Forum Stats

  • 3,769,909 Users
  • 2,253,029 Discussions


Oracle client oracle function returning trucated value in VB.NET, same code is working w

3776670 Member Posts: 1
edited Sep 5, 2018 8:36AM in .NET Stored Procedures

After upgrading our servers  facing an issue where we are calling a function in our VB.NET windows application, after providing input parameter and executing  getting truncated return value ( it should return a string 050918110744MISV5-ACDCBD-37 however it is returning 050918110744M), when i am using  same application code with oracle client 12.1 or 11g version's it is working fine issue is only with .client

Oracmd.Parameters.Add("v_material", OracleClient.OracleType.VarChar, 400).Direction = ParameterDirection.ReturnValue

Can some help to resolve this issue as we have to use Oracle client  only.

In our analysis we have found bug21616079   if is same issue please let us know what solution we can do for this.



This discussion has been closed.