IHSD
.IHS_2023
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
IHS_2023.FN_GUID_TO_RAW
Parameters
Name
Type
Mode
Definition
function fn_guid_to_raw ( guid in varchar2 ) return raw -- use AUTHID CURRENT_USER to execute with the privileges and -- schema context of the calling user AUTHID CURRENT_USER AS hex varchar2(32); begin hex := substr(guid, 7, 2) || substr(guid, 5, 2) || substr(guid, 3, 2) || substr(guid, 1, 2) -- || substr(guid, 12, 2) || substr(guid, 10, 2) -- || substr(guid, 17, 2) || substr(guid, 15, 2) -- || substr(guid, 20, 2) || substr(guid, 22, 2) -- || substr(guid, 25, 12); return hextoraw(hex); end;