GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  Concepts and Architecture

 Print  |  
Question:  how to encrypt and decrypt oracle procedure



December 12, 2007 16:23:35 #2
 ddf_dba   Member Since: December 2007    Total Comments: 2 

RE: how to encrypt and decrypt oracle procedure
 
The WRAP utility 'wraps', or hashes, the PL/SQL source code, but will not 'unwrap' it to restore the plain text starting point.  Oracle can decipher this 'translation' internally, however to edit the code one must retain the plaintext source.

WRAP is intended to obfuscate source code distributed to client sites in an effort to prevent prying eyes from seeing the underlying  logic and to prevent any unauthorized code modification by the client.

Again, there is no UNWRAP utility, so, once code is WRAPed it remains such to the naked eye.
     

 

Back To Question