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 220.127.116.11.0 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-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