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
%NOTFOUND The %NOTFOUND is logical, opposite of the %FOUND. The %NOTFOUND yields FALSE if the last fetch returned a row, or TRUE when the final fetch failed to return a row. I

Manipulating Objects: You can use an object type in the CREATE TABLE statement to indicate the datatype of a column. When the table is created once, you can use the SQL statem

Comparison Operators The Comparison operators can compare one expression to another. The outcome is always true, false, or null. Usually, you use a comparison operators in condi

Pass the nulls to a dynamic SQL: Passing Nulls: Assume that you want to pass the nulls to a dynamic SQL statement. For illustration, you may write the EXECUTE IMMEDIATE

Keyword & Parameter Description: PRAGMA: These keywords signify that the statement is a pragma (i.e. compiler directive). The Pragmas are processed at the compile time, n

Seeking a programmer to design a legal document with pre-existing fields that could allow the auto-population of client(s) information (i.e. Name, Account Number, Address etc.) int

Set Operators The Set operators combine the results of the two queries into one result. The INTERSECT returns all the distinct rows selected by both queries. The MINUS returns

Using FOR UPDATE If you declare a cursor which will be referenced in the CURRENT OF clause of an UPDATE or DELETE statement, you should use the FOR UPDATE clause to obtain an

Using Invoker Rights: By default, the stored procedure executes with the privileges of its definer, not its invoker. These procedures are bound to the schema in which they inh

Example of Alternative formulation as a table constraint Example: Alternative formulation as a table constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_