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
what is the use of declare keyword

Existential Quantification - SQL Existential quantification-stating that something is true of at least one object under consideration-can be expressed by OR(r,c), meaning tha

Delimiters A delimiter is a simple or compound symbol which has a special meaning to PL/SQL. For example, you use delimiters to symbolize an arithmetic operation like additio

Project Description: I want a small relational database to be built. I want the database to have the subsequent information tables: Employee Information Document storage

Using COUNT The COUNT returns the number of elements that a collection presently contains. For instance, when a varray projects contains 15 elements, then the following IF con

Obtaining a natural join by specifying the common columns Synatax: SELECT * FROM IS_CALLED JOIN IS_ENROLLED_ON USING ( StudentId ) However, a named columns join doe

In Packages The Forward declarations also group logically related subprograms in the package. The subprogram specifications go in the package specification, & the subprogram b

Using Aliases The Select-list items fetched from a cursor related with the %ROWTYPE should have simple names or, if they are expressions, should have aliases. In the example bel

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

Parameter and Keyword Description: EXIT: An unconditional EXIT statement (i.e., one without a WHEN clause) exits the present loop instantly. The Execution resumes with th