Forum Stats

  • 3,769,909 Users
  • 2,253,029 Discussions
  • 7,875,235 Comments

Discussions

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

3776670
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 12.2.0.1

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 12.2.0.1  only.

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

Thanks

Anoop

This discussion has been closed.