Advantages of wrapping, PL-SQL Programming

Advantages of Wrapping 

The PL/SQL Wrapper convert the PL/SQL source code into a transitional form of the object code. By hiding the application internals, the Wrapper secures:

1) The misuse of your application by the other developers.

2) The exposure of your algorithms to the business competitors.

The Wrapped code is as portable as the source code. The PL/SQL compilers recognize and load the wrapped compilation units automatically. The Other benefits include:

1) Platform independence-you do not require to deliver multiple versions of similar compilation unit

2) Dynamic loading-the users do not require shut down and re-link to add a fresh feature

3) Dynamic binding-external references are solved at the load time.

4) Strict dependency checking-the invalidated program units are re-compiled automatically

5) Normal importing and exporting-the Import/Export usefulness accepts the wrapped files

Posted Date: 10/8/2012 8:13:46 AM | Location : United States







Related Discussions:- Advantages of wrapping, Assignment Help, Ask Question on Advantages of wrapping, Get Answer, Expert's Help, Advantages of wrapping Discussions

Write discussion on Advantages of wrapping
Your posts are moderated
Related Questions
Example of Check Constraints Example: Workaround for when subqueries not permitted in CHECK constraints CREATE FUNCTION NO_MORE_THAN_20000_ENROLMENTS ( ) RETURNS BOOLEAN

Fetching with a Cursor The FETCH statements retrieve the rows in the result set one at a time. After each and every fetch, the cursor advance to the next row in the result set

CURRVAL and NEXTVAL The series is a schema object which generates the sequential numbers. Whenever you form a sequence, you can specify its primary value and an increment. T

UPDATE Statement   The UPDATE statement transforms the values of the specified columns in one or more rows in the table or view. Syntax:

Projection in SQL - correct version Student StudentId is enrolled on some course. SELECT DISTINCT StudentId FROM IS_ENROLLED_ON In more complicated examples it is someti

Passing Cursor Parameters You use the OPEN statement to pass the parameters to a cursor. Unless you want to accept the default values, each proper parameter in the cursor decl

Third Step at defining type SID in SQL CREATE DOMAIN SID AS VARCHAR(5) CHECK ( VALUE IS NOT NULL AND SUBSTRING(VALUE FROM 1 FOR 1) = 'S' AND CAST('+'||SUBSTRING(VALUE

Count Operator in SQL Example: Counting the students who have scored more than 50 in some exam (SELECT COUNT (*) FROM (SELECT DISTINCT StudentId FROM EXAM_MARK WHE

Indeterminacy in SQL Some SQL expressions are actually not function invocations at all in the mathematical sense, being indeterminate-invocations operating on identical input

Benefit of the dynamic SQL: This part shows you how to take full benefit of the dynamic SQL and how to keep away from some of the common pitfalls. Passing the Names of Sc