Skip to Main Content

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!

character string buffer too small (select list query based LOV)

Jules VerhoevenMar 12 2007 — edited Jun 28 2007
Hi,

Using the select list query based LOV with a select witch is too big, you get this error.

report error:
ORA-20001: Error fetching column value: ORA-06502: PL/SQL: numeric or value error: character string buffer too small

When using the Popup LOV query based LOV) then it works nice.

Can that be solved somehow?

With the Popup LOV the return value is displayed in stead of the description.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2007
Added on Mar 12 2007
6 comments
1,497 views