DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

3776670Sep 5 2018 — edited Sep 5 2018

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

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 3 2018

Added on Sep 5 2018

#net-stored-procedures, #windows-and-net

0 comments

1,393 views