Home » SQL & PL/SQL » SQL & PL/SQL » Key Expiration in Dbms_Obfuscation Toolkit
Key Expiration in Dbms_Obfuscation Toolkit [message #295961] Thu, 24 January 2008 00:46 Go to next message
vivpol
Messages: 6
Registered: January 2008
Location: India
Junior Member
Hi,
I'm using Oracle DBMS obfuscation Toolkit for encrypting card numbers in an application.
In this toolkit predefined functions - DES3 functions are defined etc. which use two types of keys for encryption:
1.) User supplied key
2.) key generated by DES3 function
In order to have secure user defined key, the user defined key needs to be changed periodically.
Is there any function or utility that can generate key which can be used to decrypt the encrypted data that was encrypted by old key?


Thanks in advance
vivpol
Re: Key Expiration in Dbms_Obfuscation Toolkit [message #295976 is a reply to message #295961] Thu, 24 January 2008 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dbms_random

Regards
Michel
Re: Key Expiration in Dbms_Obfuscation Toolkit [message #295993 is a reply to message #295976] Thu, 24 January 2008 02:25 Go to previous messageGo to next message
vivpol
Messages: 6
Registered: January 2008
Location: India
Junior Member
will this work on oracle 8.1.6 ?
Re: Key Expiration in Dbms_Obfuscation Toolkit [message #296004 is a reply to message #295993] Thu, 24 January 2008 03:14 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes I think, just try or search in documentation.

Regards
Michel
Re: Key Expiration in Dbms_Obfuscation Toolkit [message #296030 is a reply to message #296004] Thu, 24 January 2008 04:50 Go to previous messageGo to next message
vivpol
Messages: 6
Registered: January 2008
Location: India
Junior Member
Thanks,
But when tried 'seed' function foloowing error appears:

SQL> exec DBMS_OUTPUT.PUT_LINE(DBMS_RANDOM.SEED('Seed'));
BEGIN DBMS_OUTPUT.PUT_LINE(DBMS_RANDOM.SEED('Seed')); END;

*
ERROR at line 1:
ORA-06550: line 1, column 28:
PLS-00222: no function with name 'SEED' exists in this scope
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored



Please help me in finding where is the error.
Re: Key Expiration in Dbms_Obfuscation Toolkit [message #296032 is a reply to message #296030] Thu, 24 January 2008 04:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
desc dbms_random

seed is not a function, it is a procedure.

Regards
Michel
Re: Key Expiration in Dbms_Obfuscation Toolkit [message #296039 is a reply to message #296032] Thu, 24 January 2008 05:38 Go to previous messageGo to next message
vivpol
Messages: 6
Registered: January 2008
Location: India
Junior Member
Hi i've written following code which calls SEED procedure, but it is also giving errors:



1 create or replace function get_key
2 (
3 p_seed in varchar2
4 )
5 return varchar2
6 is
7 v_key varchar2;
8 begin
9 v_key := DBMS_RANDOM.SEED (p_seed);
10 return v_key;
11* end;
SQL> /

Warning: Function created with compilation errors.

SQL> show err
Errors for FUNCTION GET_KEY:

LINE/COL ERROR
-------- -----------------------------------------------------------------
7/8 PLS-00215: String length constraints must be in range (1 ..
32767)

9/7 PL/SQL: Statement ignored
9/16 PLS-00222: no function with name 'SEED' exists in this scope
Re: Key Expiration in Dbms_Obfuscation Toolkit [message #296040 is a reply to message #296039] Thu, 24 January 2008 05:41 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code.
Use the "Preview Message" button to verify.

2/ you will have advantage to read PL/SQL User's Guide and Reference

3/ varchar2 variable definition must contain a length.

Regards
Michel

[Updated on: Thu, 24 January 2008 05:42]

Report message to a moderator

Previous Topic: Select Cross Server
Next Topic: to find the no.of procedures in my account
Goto Forum:
  


Current Time: Tue Dec 06 10:19:31 CST 2016

Total time taken to generate the page: 0.11030 seconds