Search Tech Sites:

Oracle DBMS_OBFUSCATION_TOOLKIT »

Oracle – DBMS_OBFUSCATION_TOOLKIT: This package allows us to encrypt and decrypt values.
Here is an example on how to use the package:
—————————————————————-
FUNCTION encryptField(pi_fieldIn VARCHAR2)
RETURN RAW
IS

– 1. The input string has to be a multiple of 8 bytes…so RPAD it.
– 2. Convert VARCHAR2 to RAW to overcome DB Character Set dependencies (Useful when we are doing IMP and EXP to different
– character sets).

inputString varchar2(32767) := UTL_RAW.CAST_TO_RAW(rpad( pi_fieldIn, ceil(length(pi_fieldIn)/8)*8 , chr(0) ));
po_encrypted_string RAW(32767);

BEGIN

dbms_obfuscation_toolkit.DESEncrypt( INPUT =>inputString,
KEY => UTL_RAW.CAST_TO_RAW(‘XpVVze3F’),
ENCRYPTED_DATA => po_encrypted_string);
RETURN po_encrypted_string;
END encryptField;
————————————————————————————————–
– decryptField: Decrypts the parameter passed in and returns the decrypted string
—————————————————————————————————
FUNCTION decryptField(pi_fieldIn VARCHAR2)
RETURN RAW
IS
inputString varchar2(255) := pi_fieldIn;
po_decrypted_string RAW(32767);

BEGIN

dbms_obfuscation_toolkit.DESDecrypt( INPUT =>inputString,
KEY => UTL_RAW.CAST_TO_RAW(‘XpVVze3F’),
DECRYPTED_DATA => po_decrypted_string);

RETURN po_decrypted_string;
END decryptField;
——————————————————————————

Oracle X – XDK »

• Java based XML PL/SQL packages like XMLParser, XMLDOM and XSLProcessor are deprecated and are not included in Oracle 10g.
• You should use DBMS_XMLGEN instead of DBMS_XMLQUERY and DBMS_XMLSTORE instead of DBMS_XMLSAVE as DBMS_XMLGEN and DBMS_XMLSTORE are C based Packages.

Installing Oracle on Solaris: »

• Verify that all required Solaris packages -SUNWarc , SUNWlibms, SUNWi1of, SUNWbtool, SUNWsprot, SUNWi1cs,,SUNWhea , SUNWsprox , SUNWi15cs, SUNWlibm, SUNWtoo, SUNWxwfnt are installed. You find all these packages on Solaris CD – Disk2.

• Make changes to Kernel parameters – Edit /etc/system file using vi and set shared memory parameters.

• If you made changes to /etc/system file, you need to reboot the machine.

• Kick off runInstaller