<div>
yes.<br />
now, if you think you have a sample to reproduce the problem, please post it here, I guess we will find the &quot;problem&quot;
</div>


yes.
now, if you think you have a sample to reproduce the problem, please post it here, I guess we will find the "problem"

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
have you ever caught oracle truncating string when using these function together?<br />
<br />
upper(trim(:P21_SERV_CITY)<wbr />)
</div>
</div>


Hi,

have you ever caught oracle truncating string when using these function together?

upper(trim(:P21_SERV_CITY))

oracle trim and upper functions

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.