Hi:
I'm facing an issue that stored procedure OUT varchar2 parameters returned value truncated in Oracle client 19.x
For example, it supposed to return “SUCCESS”, but only returns “SUC”.
I have specified the length of the variable. It's an known issue in earlier versions but fixed in 12.x?
If I change the OUT parameter from varchare2 to char, it will work but with white space as char has fixed length.
I have tried ManagedDataAccess but still the same issue.
Any suggestions and work arounds?
Thanks