A script-enabled browser is required for this page to function properly.

SRW.TRUNCATED_VALUE built-in exception

This exception stops the report execution and raises one of two error messages. If the error resulted from a PL/SQL assignment, this message will be displayed:

REP-1435: Value of column <parameter/column name> was truncated.

If the error resulted from a user exit IAF PUT, this message will be displayed:

REP-1416: User exit <name> IAF PUT: value of column <parameter/column name> was truncated.

If the SRW.TRUNCATED_VALUE exception is handled, the value will be truncated and remain assigned to the parameter or column.

Syntax

SRW.TRUNCATED_VALUE;

Usage notes

Reports Builder raises this exception when a user exit or PL/SQL construct attempts to assign a value to a parameter or column which is larger than the object's maximum width.

Example

Suppose you want your own error message raised, instead of the default error message (above). You could handle this exception in the following way:

EXCEPTION
when SRW.TRUNCATED_VALUE then
srw.message(2000, 'Contact Dan Brown:  
SRW.TRUNCATED_VALUE.');  

See also

About the Reports Builder built-in package (SRW)

SRW built-in package