Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose
This package contains BASE64, Mime, Text, and UU encode and decode RAW data string functions that encode data into a standard encoded format so that the data can be transported between hosts.
This package's objects can be used to encode the body of email text. The package also contains the decode counterpart functions of the encode functions.
The functions follow published standards for encoding to accommodate non-Oracle utilities on the sending or receiving ends.
utl_encode.mimeheader_encode(
buf IN VARCHAR2 CHARACTER SET ANY_CS,
encode_charset IN VARCHAR2 DEFAULT NULL,
encoding IN PLS_INTEGER DEFAULT NULL);
RETURN string VARCHAR2 CHARACTER SET buf%CHARSET;
set serveroutput on
DECLARE
t VARCHAR2(100);
BEGIN
t := utl_encode.mimeheader_encode('MLIB');
dbms_output.put_line(t);
t := utl_encode.mimeheader_decode(t);
dbms_output.put_line(t);
END;
/
utl_encode.text_decode(
buf IN VARCHAR2 CHARACTER SET ANY_CS,
encode_charset IN VARCHAR2 DEFAULT NULL,
encoding IN PLS_INTEGER DEFAULT NULL)
RETURN string VARCHAR2 CHARACTER SET buf%CHARSET;
utl_encode.text_encode(
buf IN VARCHAR2 CHARACTER SET ANY_CS,
encode_charset IN VARCHAR2 DEFAULT NULL,
encoding IN PLS_INTEGER DEFAULT NULL)
RETURN string VARCHAR2 CHARACTER SET buf%CHARSET;
set serveroutput on
DECLARE
c VARCHAR2(100);
BEGIN
c := utl_encode.text_encode('Here is some text', 'WE8ISO8859P1', UTL_ENCODE.BASE64);
dbms_output.put_line(c);
END;
/
DECLARE
c VARCHAR2(100);
BEGIN
c := utl_encode.text_decode('SGVyZSBpcyBzb21lIHRleHQ=',
'WE8ISO8859P1', UTL_ENCODE.BASE64);