This discussion is archived
0 Replies Latest reply: Jul 25, 2013 3:26 AM by Dipak R RSS

ora-06502 pl/sql numeric or value error in Report Query in oracle apex

Dipak R Newbie
Currently Being Moderated

Hello all,

 

I need your help...

 

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


I am using bi publisher to generate PDF reports in oracle apex.

We were using APEX 4.0 and migrated to 4.2 just a week ago.

 

Now we have apex 4.2.

When I try to Create report query,

Shared Components >> Report Queries then create.

and test a report in a create wizard I am getting a error "ORA-06502: PL/SQL: numeric or value error: character string buffer too small".

I have also applied a patch "16760897".

 

This issue is because of number of columns in a query is more then 26.

If I run a report with 26 or less number of columns then the is working fine, otherwise getting this error.

My before migration report queries working perfectly even now, but not new queries.

 

This issue is also in apex.oracle.com.

You can see

Not working  - http://apex.oracle.com/pls/apex/f?p=619:4

Working - http://apex.oracle.com/pls/apex/f?p=619:2:

 

Please give a solution.

 

Thanks you.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points