RDBPROD: %SQL-E-TRUN_STORE, STRING TRUNCATED DURING ASSIGNMENT TO A COLUMN (Doc ID 958969.1)

Last updated on MAY 25, 2017

Applies to:

Oracle Rdb Server on OpenVMS - Version 7.2.4 to 7.2.4 [Release 7.2]
HP OpenVMS Itanium
HP OpenVMS Alpha

Symptoms

A PL/SQL package that uses the UPPER/LOWER case qualifiers failed, reporting %SQL-E-TRUN_STORE, String truncated during assignment to a column.

Enabling SQLNET_DEBUG_FLAGS "FH", the error is highlighted:

gtoosq.gtoosq: Sql statement....: SELECT COUNT(*) FROM USER$ WHERE
NAME = UPPER(:b1)...
.
gta.gtarpterror: sqlca.sqlcode=-306
gta.gtarpterror: Rdb err=%SQL-E-TRUN_STORE, String truncated during assignment to a column
gta.gtarpterror: ora_error_code=1401
gta.gtarpterror: Rdb operation = OPEN CURSOR, Rdb error (2):
%SQL-E-TRUN_STORE, String truncated during assignment to a column
gta.gtarpterror: exit
gta.gtaopen: exit status=1401
gtofch.gtofch: exit status=1401
gtoexe.gtoefn0: exit status=1401
gtoall.gtoalls: exit status = 1401
gtwdre.gtwdre: Oracle error 1401 for function 71, OALL7
GTWDRE exit; err = 1401
> GTWTSK AT BAD <<<
err = 1401 <<
> GTWTSK AT NO BREAK <<<
> GTWTSK AT COMPLETION MSG <<<
> GTWTSK AT HAVING SENT TOERMSG <<<
> GTWTSK AT SENDING OER, error 1401, oerrcd 1401 <<<
gtwi.gtwilom: entry
gtwi.gtwilom: error code=1401
gtwi.gtwilom: msg=ORA-01401: inserted value too large for column
gtwi.gtwilom: exit

This problem affects functions such as UPPER, LOWER, etc., that are passed parameters and should be estimating larger data types.

Changes

Upgraded to Oracle Rdb 7.2.4.0

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