APEX

Hello All,

I'm encounter error ORA-06502: PL/SQL numeric or value error: character string buffer too small on a dynamic list of values and so far I can determine that the trouble stems from the number or rows returned.

My report is an SQL Query(updateable report) and columns can be updated based on a dynamic lov query.

It currently seems to have a limit of 28 rows where I need it to return rows based on my dynamic lov query which could climb up to maybe 50 rows. I can remove rows from my table and add new ones but as long as it does not exceed 28 returned rows it displays with no errors, but if I attempt to add additional rows to the table which I call in my query it results in ORA-06502 error.

I read through some of the posts and some suggested to changed the tabular form element to "Popup LOV(based on query) but that did not seem to help.

Is there a way to increase the number of rows returned in this situation? I'm hoping it is a simple oversight on my part.

Any help will be appreciated.

Thank you.