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
Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent

Scope and Visibility The References to an identifier are resolved according to its visibility and scope. The scope of an identifier is that area of a program unit (subprogram, b

Example of Tables within a Table - SQL Example: Obtaining C_ER from COURSE and EXAM_MARK SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM_MARK AS EM

i NEED THE QURIES TO SOME OF THE PROBLEMS USING plsql

OPEN-FOR Statement The OPEN-FOR statements execute the multi-row query related with a cursor variable. It also allocates the resources used by the Oracle to process the query a

Write an anonymous block that contains a PL/SQL procedure. The procedure takes two input parameter: oldZip and newZip, and it updates the zipcodes table by replacing all oldZip wit

Running the PL/SQL Wrapper To run the PL/SQL Wrapper, go through the wrap command at your operating system prompt by using the syntax as shown: wrap iname=input_file [oname=

Committing and Rolling Back The COMMIT and ROLLBACK end the active autonomous transaction but do not exit the autonomous routine. As the figure shows, if one transaction ends,

UNION and OR - SQL SQL supports UNION explicitly but differently from the way it supports JOIN explicitly. As we have seen, JOIN is used exclusively within the FROM clause, su

Declaring Subprograms   You can declare subprograms in any PL/SQL subprogram, block, or package. But, you should declare subprograms at the end of the declarative part after a