Skip to Main Content

DevOps, CI/CD and Automation


For appeals, questions and feedback, please email

Oracle Stored Procedure truncating the output in the varchar parameter in oracle 19c client

User_Y1RAENov 1 2022

Hi All,
I am using Oracle 19c client for the Oracle 11g Database.
The application is using System.Data.OracleClient.dll to connect to the Database.
Application connects to the procedure and the procedure return a varchar in the Output parameter. Unfortunately the output text is getting truncated.

Did anyone face this issue. If so what is the work around for this.
Note: I cannot change anything in the code as this will trigger to test all the applications depended on this.

Post Details
Added on Nov 1 2022