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
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!!!!!
Discussion about this article
| Author | Body |
Rahul
8/29/2009 10:12 PM
|
Please provide feedback about this article here.
To participate in this discussion Sign up for free membership of 24x7code.
To Signup click on Login , Use create user link & the follow the instructions.
Thank you
|