Skip to Main Content
Forums

SQL & PL/SQL

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 truncates Java String when mapping to VARCHAR2

277106Jul 6 2002
Ive published Java method as a function. The Java method returns a string value, which is mapped into VARCHAR2 type in the call spec.
Everything works fine when the returned sting is less then 4097 bytes in length. Once the returned string is over 4097 bytes Oracle truncates it to 4097.
PL/SQL limit size for VARCHAR2 is 34K so theoretically there shouldnt be a problem.

Any ideas how to fix this problem?

Thanks,
Irek
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2002
Added on Jul 6 2002
1 comment
251 views