Create OLS Label Fails 'ORA-12427: invalid input value for label tag parameter' (Doc ID 2486179.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

BEGIN lbac_label_admin.create_label(........); END;

*
ERROR at line 1:
ORA-12427: invalid input value for label tag parameter
ORA-06512: at "LBACSYS.LBAC_STANDARD", line 20
ORA-06512: at "LBACSYS.LBAC_LABEL_ADMIN", line 89
ORA-06512: at line 1

here LABLE_TAG  > 99999999 Say, LABLE_TAG = 1000000000

Use case:

+++++

To successfully import data under OLS, we need to create OLS policies and
label components on the target database before the data can be imported
successfully.

If the individual labels do not exist in the import database with the same
numeric values and the same character string representations as in the export
database, then the label values in the imported tables will be meaningless.
The numeric label value in the table may refer to a different character
string representation, or it may be a label value that has not been defined
at all in the import database.

To create these labels on the target database, one has to use,
SA_LABEL_ADMIN.CREATE_LABEL procedure.

If the labels created in the source database are dynamic ones, the label tag
will be 10 digits and any attempt to create the same label in the target
database would fail with the following error.

SQL> BEGIN
2 SA_LABEL_ADMIN.CREATE_LABEL('HUMAN_RESOURCES', 1000000000, 'L1');
3 END;
4 /
BEGIN
*
ERROR at line 1:
ORA-12427: invalid input value for label tag parameter
ORA-06512: at "LBACSYS.LBAC_STANDARD", line 20
ORA-06512: at "LBACSYS.LBAC_LABEL_ADMIN", line 89
ORA-06512: at line 2

Cause

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