ORA-06502 When Running Report Request from SRW API and SRW.Add_parameter Value is Over 255 (Doc ID 1433483.1)

Last updated on APRIL 29, 2015

Applies to:

Oracle Reports Developer - Version 11.1.2.0.0 and later
Information in this document applies to any platform.
"Checked for relevance on 29-Apr-2015"

Symptoms

When attempting to run a report using the SRW API for event based reporting,
the following error occurs.

ERROR
-----------------------
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "REPORTS.SRW", line 734
ORA-06512: at line 16


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a procedure to run a report from the SRW API.
2. If the report request contains a parameter that has more than 255 characters the error occurs, if the report request has fewer character the procedure is successful.


BUSINESS IMPACT
-----------------------
Report requests ran from a procedure fails if the parameter string is over 255 characters.

Changes

Upgraded to Reports 11.1.2.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms