Name

xenc_get_key_identifier — Determine a key identifier

Synopsis

varchar xenc_get_key_identifier ( in key_name varchar );

Description

The function returns key identifier.

Parameters

key_name

Name of the key

Return Types

The function returns a base64 encoded string containing the key identifier. If key identifier is not available (the key have no identifier or key does not exists a NULL will be returned).

Examples

Example24.463.Determine the key identifier

SQL> select xenc_get_key_identifier ('myKey');
callret
VARCHAR
_______________________________________________________________________________

LtVJHvVXJFFvzRnfrCaKmdxQaGQ=