ORA-06502: PL/SQL: Numeric or Value Error While Executing TMS_USER_FULLAUTOCODE (Doc ID 1339504.1)

Last updated on MARCH 02, 2015

Applies to:

Oracle Thesaurus Management System - Version 4.5.2 and later
Information in this document applies to any platform.
*** Checked for currency: 02-Mar-2015 ***

Symptoms

 Errors while executing the package TMS_USER_FULLAUTOCODE

ORA-06502: PL/SQL: numeric or value error: character string buffer too small


The parameters that are passed are as below:

error:=new_ntr.classifyterm(pDefDictionaryId=>8,
pDefDomainId=>1,
pTerm=>'PBS',
pSourceTermId=>107125,
pOccurrenceId=>0,
pSourceTermAltKey=>null,
pNoOmissionFlag=>'N',
pDefIntegrationKey=>'REGISTRY',
pDefInstanceName=>'REGP1.PFIZER.COM',
pXArea=>0,
pExtValue1=>substr('B257',1,32) ,
pExtValue2=>substr('3134K1-2201',1,32),
pExtValue3 =>substr('WYETH',1,32),
pExtValue4=>
substr('RIGHTRACK//FRANCILLARD, NATHALIE (17437084)',instr('RIGHTRACK//FRANCILLARD, NATHALIE (17437084)','//')+2,32),
pExtValue5=>to_char(to_date('6/22/2011 12:39:16 PM','MM/DD/YYYY HH:MI:SS PM')),
pExtValue6=> 'WAPI',
pExtValue7=> substr('PROTOCOL_DRUG',1,32),
pExtValue8=> null,
pOmissionStatus=>pOmissionStatus,
pOmissionOwner=>pOmissionOwner,
pActionText=>action_text,
pSearchId=> pSearchId,
pVTAiD=>pVTAID ,
pDeriveValues=>pDeriveValues);



The error that is generated is as below:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "TMS.TMS_USER_AUTOCODE", line 1091
ORA-06512: at "TMS.TMS_USER_AUTOCODE", line 1325
ORA-06512: at "TMS.TMS_USER_FULLAUTOCODE", line 303
ORA-06512: at "TMS.TMS_USER_FULLAUTOCODE", line 611
ORA-06512: at "TMS.TMS_USER_FULLAUTOCODE", line 730

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