PL/SQL Wrapper

PL/SQL Wrapper

To hide the source code from the user.
Ed c:\details.sql  (Creating a .sql file)

create or replace procedure details
as
begin
dbms_output.put_line(‘The password of the account is XYDFZ’);
end;

SQL> @ c:\details.sql 

select text from user_source where name = ‘DETAILS’;
Type the wrap command on the command prompt.
wrap iname=details.sql oname=wrapped_details.sql

p10

Now compile the wrapped_details.sql file on the SQL prompt
@c:\wrapped_details.sql

select text from user_source where name = ‘DETAILS’;

The code gets encrypted!!!!!

 

Posted in UncategorizedTagged