NIM037121 for No Product Found

Bug ID Number	NIM037121
Submitted	July 30, 2008
Last Modified	June 5, 2024
Applies to	No Product Found
Version found	9.3
Version Fixed	9.4
Status	Fixed

Description

Attempting to rename an Oracle table fails with an underlying DBMS error:

"SQL> RENAME tr_conductoranno100cond_bk TO tr_conductoranno100cond;
RENAME tr_conductoranno100cond_bk TO tr_conductoranno100cond
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 1"

Cause

This DBMS error occurs because a local string variable's length in the sde trigger st_rename_table is not defined large enough to support an input string value.

Anytime a table is renamed in Oracle, the sde trigger st_rename_table is executed to check if the table being renamed contains a sde.st_geometry attribute and updates the st_geometry metadata accordingly in the SDE schema.

Workaround

If this error is encountered when attempting to rename a table in Oracle, please contact ESRI Support Services and reference this knowledge base (KB) article.