My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

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

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
Symptoms
Cause
Solution
References


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