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!

Error ORA-06502 when using an interactiv report with a large numbre of columns

Bruno POTIERFeb 28 2024

Hello,

it seems that we encounter a limit when adding some columns in an interactive report, but we don't know if it's a bug or if not what is the limit

here is the stack from the debug mode

Error: ORA-06502: PL/SQL : erreur numérique ou erreur sur une valeur: tampon de chaîne de caractères trop petit 
- Additional info: 
- Display location: 
- Association type: 
- Item name: 
- Region id: 
- Column alias: 
- Row: 
- Model instance id: 
- Model record id: 
- Internal error: false 
- Common runtime error: false 
- APEX error code: 
- SQL code: -6502 
- SQL error: ORA-06502: PL/SQL : erreur numérique ou erreur sur une valeur: tampon de chaîne de caractères trop petit 
ORA-06512: à "APEX_230200.WWV_FLOW_IR_RENDER", ligne 9410 
ORA-06512: à "APEX_230200.WWV_FLOW_IR_RENDER", ligne 8545 
- Backtrace: ORA-06512: à "APEX_230200.WWV_FLOW_IR_RENDER", ligne 9410 
ORA-06512: à "APEX_230200.WWV_FLOW_IR_RENDER", ligne 8545 
ORA-06512: à "APEX_230200.WWV_FLOW_IR_RENDER", ligne 14237 

- Statement: 
- Component: APEX_APPLICATION_PAGE_REGIONS &P0_X_TITRE. (62262988088181713)

Thanks

Comments
Post Details
Added on Feb 28 2024
1 comment
395 views