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!

Buffer error using APEX_ITEM

Luis KefurApr 11 2011 — edited Apr 11 2011
I have this query on a apex report:

select APEX_ITEM.TEXT(1, ATRIBUTO, 30) "Attributes"
,ATRIBID
,VALOR "Actual Value"
,APEX_ITEM.SELECT_LIST_FROM_QUERY(2
,ATRIB_VLR_ID
,'select VALOR
,ID
from ATRIBBVAL
where ATRIB_ID = ' || ATRIBID||'
order by valor') "Answers"
from APEX_TEMP
where PRODUCT = :P3_PRODUCT
and APP_SESSION = :APP_SESSION;

I have a lot of products that que query executes perfectlly.
But i have too a group of products that when i want to execute, it gives the error:

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

When i reduce the number of answer rows (vide example bellow) in the SELECT_LIST_FROM_QUERY the error does not occours.

select APEX_ITEM.TEXT(1, ATRIBUTO, 30) "Attributes"
,ATRIBID
,VALOR "Actual Value"
,APEX_ITEM.SELECT_LIST_FROM_QUERY(2
,ATRIB_VLR_ID
,'select VALOR
,ID
from ATRIBBVAL
where ATRIB_ID = ' || ATRIBID||'
and rownum <= 90
order by valor') "Answers"
from APEX_TEMP
where PRODUCT = :P3_PRODUCT
and APP_SESSION = :APP_SESSION;

Any sugestion to help me?

The apex i'm using in this case is 3.2.1 and the database 11.2.0.1.0.
This post has been answered by fac586 on Apr 11 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 9 2011
Added on Apr 11 2011
1 comment
619 views