Re:Data encryption in Oracle 7.x

2001-05-21 Thread dgoulet
Val, I doubt that this does DES encryption, but it may be better than nothing and it does work in Oracle7. (atually came from MetaStink) create or replace package encrypt as function code(inp_data varchar2, key varchar2 default 'FILL IN THE BLANK') return varchar2; pragma

Re:data encryption

2001-05-03 Thread dgoulet
Gyula, Assuming your not on a version or Oracle that supports DBMS_OBFUSCATION you can try the following package. It's actually been copied from a Metalink doc. create or replace package encrypt as function code(inp_data varchar2, key varchar2 default 'your desired value') return