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
SQL Database: So, an SQL database is one whose symbols are organized into a collection of tables. Now, shows an SQL table as the current value of an SQL variable, ENROLMENT, b

%TYPE Attribute The %TYPE attribute gives the datatype of a record, field, nested table, database column, or the variable. You can use the %TYPE attribute as the datatype speci

Example of COALESCE operator Example: Give the total of marks for each exam (simplified solution) SELECT CourseId, COALESCE ((SELECT SUM (Mark) FROM EXAM_MARK AS EM

Named Notation The second procedure call uses the named notation. An arrow (=>) serve as the relationship operator that associates the formal parameter to the left of the arro

EXECUTE Privilege To call an invoker-rights routine straightforwardly, the users should have the EXECUTE privilege on that routine. By yielding the privilege, you permit a user

Example of Shorthand for a row constraint Example: Shorthand for a row constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Mark_in_range CHECK (Mark BETWEEN 0 AND 100);

Controlling Autonomous Transactions The first SQL statement in an autonomous routine starts a transaction. Whenever one transaction ends, the next SQL statement starts the oth

Comparison Operators Usually, you use the comparison operators in the WHERE clause of a data manipulation statement to form the predicates, that compare one expression to anot

Example of GROUP BY and COLLECT Operator Example: Using GROUP BY and COLLECT to obtain C_ER2 SELECT CourseId, CAST ( COLLECT (ROW (StudentId, Mark)) AS ROW (Studen

Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T