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 and later
Information in this document applies to any platform.
"Checked for relevance on 29-Apr-2015"


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

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

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.

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


Upgraded to Reports 11.1.2.


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