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
If two relations R and S are joined, then the non matching tuples of both R and S are ignored in __________________.

Using INNER JOIN INNER JOIN is used to retrieve the data from all tables listed based on a condition of equality listed after keyword ON. If the condition is not meet, rows ar

Declarations in SQL Your program stores values in the variables and constants. As the program executes, the value of the variables can change, but the values constants cannot.

Using DELETE This process has three forms. The DELETE removes all elements from the collection. DELETE(n) removes the nth element from the nested table. When n is null, then D

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=

Datatype Conversion At times it is necessary to convert a value from one datatype to another. For e.g. if you want to inspect a rowid, you should convert it to a character stri

EXECUTE IMMEDIATE Statement   The EXECUTE IMMEDIATE statement prepare (parses) and instantly executes a dynamic SQL statement or an anonymous PL/SQL block. Syntax:

SELECT INTO Statement   The SELECT INTO statement retrieve data from one or more database tables, and then assigns the selected values to the variables or fields. Syntax:

What Is a Collection The collection is an ordered group of elements, all of similar type (for e.g. the grades for a class of students). Each element has a unique subscript whic

Parameter Modes   To define the behavior of formal parameters you use the parameter modes. The 3 parameter modes, IN, OUT, & IN OUT, can be used with any subprogram. Though, a