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!

Using HTP.P and 'ORA-06502: PL/SQL: numeric or value error'

TamasSzecsyJul 25 2011 — edited Jul 25 2011

Hi,

We use APEX 4.0, Oracle 10gR2 and Oracle iAS 10g.

I am trying to use OWA_UTIL and HTP.P for generating an Excel output. I created a PKG_EXCEL_GEN package that generates the Excel XML output. The APEX PROCESS is calling the PKG_EXCEL_GEN package and it is calling procedures in the built OWA_UTIL and HTP packages.

I keep getting *'ORA-06502: PL/SQL: numeric or value error: character string buffer too small'* and simply can not understand why. Did any one here encounter this situation? TIA

Regards, Tamas

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 22 2011

Added on Jul 25 2011

#apex, #apex-discussions

1 comment

1,555 views