long string
Posted: Thu Jul 17, 2003 10:10 pm
Hello,__I^m using ARPEGGIO version 2.0 report designer.____I designed a report with SQL statement as follows.__ select emp_no, remarks from emp;____This table is defined on oracle 9.2.0 as follows.__ create table emp (__ emp_no char(8),__ remarks varchar2(2000)__ );____When I print this report, remarks field turns into garbage.__If I modify SQL as follows, no garbled.__ select emp_no, substr(remarks, 1, 80) from emp;____But if I change length of substr to 81, garbled again.____Q1. Has this problem been resolved in the latest version of R&R?__Q2. Can I resolve this program in the my ARPEGGIO?____Thank you,__