-------------- HEX CONVERSION ----------------
CREATE OR REPLACE FUNCTION SCP.DEC_STR (
I_OWNER IN VARCHAR2,
I_TABLE IN VARCHAR2,
I_COLUMN IN VARCHAR2,
I_DATA IN VARCHAR2
)
RETURN VARCHAR2 PARALLEL_ENABLE DETERMINISTIC IS
BEGIN
IF I_DATA IS NULL THEN
RETURN NULL;
END IF;
RETURN UTL_RAW.CAST_TO_VARCHAR2(I_DATA);
EXCEPTION
WHEN OTHERS THEN
RAISE_APPLICATION_ERROR (-20010, TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 11, 1024) );
RETURN NULL;
END;
-------------- HEX CONVERSION ----------------
CREATE OR REPLACE FUNCTION SCP.ENC_STR (
I_OWNER IN VARCHAR2,
I_TABLE IN VARCHAR2,
I_COLUMN IN VARCHAR2,
I_DATA IN VARCHAR2
)
RETURN VARCHAR2 PARALLEL_ENABLE DETERMINISTIC IS
BEGIN
IF I_DATA IS NULL THEN
RETURN NULL;
END IF;
RETURN UTL_RAW.CAST_TO_RAW(I_DATA);
EXCEPTION
WHEN OTHERS THEN
RAISE_APPLICATION_ERROR (-20010, TO_CHAR(SQLCODE) || ' ' || SUBSTR(SQLERRM, 11, 1024) );
RETURN NULL;
END;