Skip to Main Content

ODP.NET

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 19.x SP OUT varchar2 parameter truncated

user-y05gsOct 2 2023

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

This post has been answered by Alex Keh-Oracle on Oct 14 2023
Jump to Answer
Comments
Post Details
Added on Oct 2 2023
6 comments
1,197 views