Can you clear your Requirement ? DBMS_CRYPTO is intended to replace the DBMS_OBFUSCATION_TOOLKIT (prior to Oracle 10g), since it is easier to use and supports a range of algorithms accommodating both new and existing systems.
The DBMS_CRYPTO package enables encryption and decryption large objects (CLOB, BLOB), such as images and sound.
See DBMS_CRYPTO and DBMS_OBFUSCATION_TOOLKIT Feature Comparison
(The DBMS_OBFUSCATION_TOOLKIT is granted to PUBLIC by default. Oracle Corporation strongly recommends that you revoke this grant.)
(Do not use DBMS_RANDOM as it is unsuitable for cryptographic key generation.)
Good morning from Canary Island ;)
My case is the following:
Actually, we are work with Oracle Lite. We have one database Oracle 10g in central, and our device have Oracle Lite.
En la base de datos central quiero utilizar un paquete para encriptar, por ejemplo, DBMS_OBFUSCATION_TOOLKIT o cómo tú dices "DBMS_CRYPTO".
In the central database, i will use to encrypt a package, for example, DBMS_OBFUSCATION_TOOLKIT, or how you say "DBMS_CRYPTO".
My question is:
There is a package in Oracle Lite that can be used to decrypt the encrypted fields in central database?
It is not possible to use PLSQL package with ORacle Lite DB.
Oracle Lite Does not provide API in the Database to encrypt a particular column, but you can encrypt the full olite DB.
You can plug-in a custom encryption module for the Oracle Lite database by adding the EXTERNAL_ENCRYPTION_DLL parameter to the POLITE.INI configuration file. Use this if you do not want to use the default AES encryption provided for the client database.
You must either implement your encryption module into a DLL for the Windows environment or into a Shared Object (.SO) for the UNIX environment.
For example, if you created the encryption module as a DLL called my_enc.dll, which is located in the C:\my_dir directory, then you would add this module as the default encryption module in the POLITE.INI configuration file, as follows:
For more information, see Section 14.3, "Providing Your Own Encryption Module for the Client Oracle Lite Database".