My Oracle Support Banner

Pin_rel.Get_service_tables_str Fails If The Length Of Service_table_names Is Greater Than 255 (Doc ID 1361338.1)

Last updated on MARCH 23, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version and later
Information in this document applies to any platform.


Recently a new *service* table, named event_dlyd_sess_tlco_chr_t, had been defined for loading some custom information via pin_rel;
but the pin_rel failed with the following error:

ORA-20011: An unexpected error occurred in the preupdate procedure
ORA-06512: at "BTO_PIN17.PIN_REL", line 4330
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

 When  renamed the new service table to evt_dlyd_chr_t (12 chars less) , the pin_rel works properly.

 The issue is caused by a variable of pin_rel.get_service_tables_str function, wrongly defined as varchar(255) instead of rel_sub_processes_t.tables%type.

  The string usually stored in rel_sub_processes_t.tables is:


the length is 299 but the length of service tables (not considering "event_t;event_bal_impacts_t;event_essentials_t;") is 252, less than 255.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.