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!

Report suddenly showing ORA-20001: Error fetching column value: ORA-06502:

MartinFJan 28 2008 — edited Jan 30 2008
Hi,
Some reports in my applications are suddenly showing:
ORA-20001: Error fetching column value: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
instead iof the data they used to show.
.
In my development system I can fix this by:
1. changing the column alias in my sql

select 'a' alias1 from dual becomes
select 'a' alias2 from dual

2. SAVE CHANGES

3. change column alias back to original

select 'a' alias2 from dual becomes
select 'a' alias1 from dual

4. reorder columns back to original in the 'report attributes' tab

alias1 is now at the bottom of my colum list - i just bounce it up to column 4 using the up arrows

5. SAVE CHANGES
.
then everything starts working OK again.

There seems to be nothing wrong with my sql as I can make it works on a new page or after I run the above steps, so I guess something is breaking somewhere but I cannot work out what.

Has anyone else seen this? Does anyone know the cause? Does anyone have a fix for this that does not involve the above steps (plus redeployment to prodcution and all the work that involves)?

I am seeing this on version 2.3 and 3.0.

Thanks,
Martin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 27 2008
Added on Jan 28 2008
10 comments
8,177 views