How pl/sql source code can be protected?
Answers were Sorted based on User's Feedback
Answer / abbireddy anil kumar
using wrap utility we can protect the pl/sql code
this utility can change the pcode into ascci format
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / balakrishna
You can use DBMS_DDL.CREATE_WRAPPED to protect/encript the
code.
Is This Answer Correct ? | 6 Yes | 0 No |
take procedure or function that u want to wrap
e.g proc_out_data
step 1:- create a sql file and save into a directory.
step 2: go to file location through cmd
step 3: wrap iname=file_name_to_be_wrapped.sql
step4: check a new file is created with same name but extension
file_name_to_be_wrapped.plb
step5:- compile this nely created file's text
step6: your code is now wrapped.
Is This Answer Correct ? | 0 Yes | 0 No |
What are the return values of functions SQLCODE and SQLERRM ?
Can a select statement fire a trigger?
What are transaction and its controls?
what is self join and how it works??
What is the use of primary key?
Why use truncate instead of delete?
Explain architecture of sql server notification services?
Are there any features that are decommissioned in 11g that are not present in 11g?
What is the use of count (*) in sql?
What is a Procedure ?
Which is better trigger or stored procedure?
Is natural join same as inner join?