APEX

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!

Uppercase/Lowercase mismatch issue when selecting a row

3889Oct 21 2008 — edited Oct 22 2008

I am new to APEX and am sure this is an easy one to answer.

I have a report and form. On the report screen, I have a textitem called P1_JOB_NAME which holds the JOB_NAME value returned from a SQL select. The JOB_NAME values are coming back from the table in mixed case, both lower and upper. In order to have the P1_JOB_NAME column sort properly on the report screen, I added the UPPER() function to the SQL select to force the values to uppercase and the sort issue has been solved.

However, because of this, when I attempt to edit a record, I am receiving a NO DATA FOUND error because the value in P1_JOB_NAME is now uppercase and the data in the table is lowercase. What is the easiest fix for this problem?

Thanks,

Jason

This post has been answered by Roel Hartman on Oct 22 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 19 2008

Added on Oct 21 2008

#apex-discussions

9 comments

586 views