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
Passing Cursor Parameters You use the OPEN statement to pass the parameters to a cursor. Unless you want to accept the default values, each proper parameter in the cursor decl

Effects of NULL for UNIQUE Specification When a UNIQUE specification u for base table t includes a column c that is not subject to a NOT NULL constraint, the appearance of sev

Package STANDARD The package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available

%FOUND Until the SQL data manipulation statement is executed, the %FOUND yields NULL. Afterward, the %FOUND yields TRUE, when an INSERT, UPDATE, or DELETE statement affected o

Many of the reports generated from the system calculate the total dollars in a shopper''s purchases. Follow these steps to create a function named TOT_PURCH_SF that accepts a shopp

Mutual Recursion The Subprograms are mutually recursive if they directly or indirectly call each other. In the illustration below, the Boolean functions odd & even, that dete

Parameter and Keyword Description: record_type_name: This identifies the user-defined type specifier that is used in the subsequent declarations of the records. NOT N

Predefined Exceptions The internal exception is raised implicitly whenever your PL/SQL program exceeds a system-dependent limit or violates an Oracle rule. Each & every Oracle

Question: Consider the following relations (primary keys are underlined): AUTHOR (ANo, aname, address, speciality) PUBLISHER (PNo, pname, Location) BOOK (BNo, Title, ISBN,

what is the use of declare keyword