x
login about faq Site discussion (meta-askssc)

How can I protect my PL/SQL source code?

I think this is very important to the every developer to know. I want to know how can we protect the PL/SQL source code, so that we can hide the logic what we used to develop the code.

more ▼

asked Jan 07 '10 at 11:22 AM in Default

OracleApprender gravatar image

OracleApprender
763 54 67 73

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

PL/SQL V2.2, available with Oracle7.2, implements a binary wrapper for PL/SQL programs to protect the source code.This is done via a standalone utility that transforms the PL/SQL source code into portable binary object code (somewhat larger than the original).This way you can distribute software without having to worry about exposing your proprietary algorithms and methods.SQL*Plus and SQL*DBA will still understand and know how to execute such scripts.Just be careful, there is no "decode" command available. The syntax is: wrap iname=myscript.sql oname=xxxx.yyy

more ▼

answered Jan 11 '10 at 11:01 AM

OracleApprender gravatar image

OracleApprender
763 54 67 73

(comments are locked)
10|1200 characters needed characters left

Depends what you mean.

Use packages to hide implementation details from people using the interface. (Good development practice).

Use the Wrap utility to hide the source code from view: http://download.oracle.com/docs/cd/E11882_01/appdev.112/e10472/wrap.htm#BABEFEJF

more ▼

answered Jan 07 '10 at 11:33 AM

Andrew Mobbs gravatar image

Andrew Mobbs
1.5k 1 3

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x362
x50

asked: Jan 07 '10 at 11:22 AM

Seen: 1061 times

Last Updated: Jan 07 '10 at 11:22 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.