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
%ISOPEN The %ISOPEN yields TRUE if its cursor or cursor variable is open; or else, the %ISOPEN yields FALSE. In the illustration, you use the %ISOPEN to select an action:

Using a Join on 2 tables, select all columns and all rows from the tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 JOIN CONTRACT ON EMPLOYEE

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma

%ROWCOUNT The %ROWCOUNT yields the number of rows affected by the INSERT, UPDATE, or DELETE statement, or returned by a SELECT INTO statement. The %ROWCOUNT yields zero when a

Manipulating Local Collections Within PL/SQL, to manipulate the local collection, by using the  TABLE and CAST operators . The operands of CAST are a collection declared locally

Advantages of PL/SQL The PL/SQL is a high-performance transaction processing, completely portable language that offers the following advantages as shown: 1) Support for SQL

Positional and Named Notation You can write the actual parameters when calling a subprogram, using either positional or named notation. That is, you can point to the relationsh

Data Types in SQL - Decimal DECIMAL, NUMERIC, REAL, FLOAT and various other terms for various sets of rational numbers. When these key words are specified for the declared typ

Using LIMIT For nested tables, that have no maximum size, the LIMIT returns NULL. For varrays, the LIMIT returns the maximum number of elements that a varray can have (that yo

Example of Table Literal - SQL Example: A Table Literal (correct version) VALUES ('S1', 'C1', 'Anne'), ('S1', 'C2', 'Anne'), ('S2', 'C1', 'Boris'), ('S3', 'C3'