Running the pl/sql wrapper, PL-SQL Programming

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=output_file]

It Leave no space in the region of the equal signs as spaces delimit the individual arguments.

The wrap command needs only one argument, which is as shown:

iname=input_file

where the input_file is the path and name of the Wrapper input file. You do not require specifying the file extension as it defaults to sql. For illustration, the commands below are equivalent:

wrap iname=/mydir/myfile

wrap iname=/mydir/myfile.sql

Though, you can specify a various file extension as the illustration below shows:

wrap iname=/mydir/myfile.src

Optionally, the wrap command takes a second argument, which is as shown:

oname=output_file

where the output_file is the path and name of the Wrapper output file. You do not require specifying the output file as its name defaults to that of the input file and its extension defaults to the plb (PL/SQL binary). For illustration, the commands below are equivalent:

wrap iname=/mydir/myfile

wrap iname=/mydir/myfile.sql oname=/mydir/myfile.plb

Though, you can use the choice oname to specify a various file name and extension, as the illustration below shows:

wrap iname=/mydir/myfile oname=/yourdir/yourfile.obj

Posted Date: 10/8/2012 8:14:23 AM | Location : United States







Related Discussions:- Running the pl/sql wrapper, Assignment Help, Ask Question on Running the pl/sql wrapper, Get Answer, Expert's Help, Running the pl/sql wrapper Discussions

Write discussion on Running the pl/sql wrapper
Your posts are moderated
Related Questions
Renaming Columns - SQL SQL has no direct counterpart of RENAME. To derive the table on the right in Figure 4.4 from the table on the left, Tutorial D has IS_CALLED RENAME ( St

Using the FORALL Statement The keyword FORALL instruct the PL/SQL engine to bulk-bind input collections before sending them all to the SQL engine. Though the FORALL statement

Object Type: The object type is a user-defined composite datatype which encapsulates a data structure along with the functions and procedures required to manipulate the data

Closing a Cursor The CLOSE statements disable the cursor, and the result set becomes undefined. An illustration of the CLOSE statement as shown: CLOSE c1;

Conditionals - SQL At first sight SQL does not appear to have a single operator for expressing logical implication. In this respect it would be in common with most programming

Project Description: I want to rebuild it and add better content to it It will include up to 5 forms The data will be saved on SQL server and the data access layer could b

Predicate - SQL Consider the declarative sentence-a proposition-that is used to introduce this topic:  "Student S1, named Anne, is enrolled on course C1." Recall that th

Transaction context As the figure shows, the major transaction shares its context with the nested transactions, but not with the autonomous transactions. Similarly, If one aut

Initial thought process: Design a script which was simple and user friendly. Integrate procedures/functions to extract data under the hood. I focused on giving the user the opt

COSMOZOI C THEORY - Richter (1865) proposed the cosmozoic theory that says that life came by spores (cosmozoa) or other particles from other planets on the earth.