The Program Used To Create This Object Is Package Word

admin

Purpose

Dec 03, 2012  Micrsoft Word - The program used to create this object is Package. That program is either not installed on your computer or is not responding.

Use the CREATEPACKAGEBODY statement to create the body of a stored package, which is an encapsulated collection of related procedures, stored functions, and other program objects stored together in the database. The package body defines these objects. The packagespecification, defined in an earlier CREATEPACKAGE statement, declares these objects.

Packages are an alternative to creating procedures and functions as standalone schema objects.

See Also:

  • CREATE FUNCTION and CREATE PROCEDURE for information on creating standalone functions and procedures

  • CREATE PACKAGE for a discussion of packages, including how to create packages

  • 'Examples' for some illustrations

  • ALTER PACKAGE for information on modifying a package

  • DROP PACKAGE for information on removing a package from the database

Prerequisites

Before a package can be created, the user SYS must run a SQL script commonly called DBMSSTDX.SQL. The exact name and location of this script depend on your operating system.

To create a package in your own schema, you must have CREATEPROCEDURE system privilege. To create a package in another user's schema, you must have CREATEANYPROCEDURE system privilege.

To embed a CREATEPACKAGEBODY statement inside an Oracle Database precompiler program, you must terminate the statement with the keyword END-EXEC followed by the embedded SQL statement terminator for the specific language.

Syntax

create_package_body::=


Description of the illustration create_package_body.gif

Semantics

OR REPLACE

Specify ORREPLACE to re-create the package body if it already exists. Use this clause to change the body of an existing package without dropping, re-creating, and regranting object privileges previously granted on it. If you change a package body, then Oracle Database recompiles it.

Users who had previously been granted privileges on a redefined package can still access the package without being regranted the privileges.

See Also:

ALTER PACKAGE for information on recompiling package bodies

schema

Specify the schema to contain the package. If you omit schema, then the database creates the package in your current schema.

package

Specify the name of the package to be created.

pl/sql_package_body

Specify the package body, which can contain PL/SQL subprogram bodies or call specifications, which are declarations of a C or Java routine expressed in PL/SQL.

See Also:

  • Oracle Database Application Developer's Guide - Fundamentals for more information on writing PL/SQL or C package program units

  • Oracle Database Java Developer's Guide for information on Java package program units

  • 'Restrictions on User-Defined Functions' for a list of restrictions on user-defined functions in a package

Examples

Creating a Package Body: Example This SQL statement creates the body of the emp_mgmt package created in 'Creating a Package: Example'. The PL/SQL is shown in italics:

The package body defines the public program objects declared in the package specification:

Aisc steel tables pdf. For angle legs = 5', the potential for two rows of bolts exists.

  • The functions hire and create_dept

    Shopping is made easy through the easy checkout process with High Security offerings like 256 Bit SSL Certificate provided by Global Safe Security Providers-Verisign so that your online transactions are absolutely safe and secured.At SapnaOnline we believe that customer satisfaction is utmost important hence all our efforts are genuinely put into servicing the customer's in the best possible way. SapnaOnline offers Free shipment all across India for orders above Rs199 and Global Shipment at the most economical cost. SapnaOnline provides online shopping for over 10 Million Book Titles in various languages and genres. Along with Books, at SapnaOnline, one can shop for over 10,000 Audio Books, 5000 Electronics and Accessories products and over 1000 Toys,Health Care and Home products. Iit maths by ml khanna pdf.

  • The procedures remove_emp, remove_dept, increase_sal, and increase_comm

These objects are declared in the package specification, so they can be called by application programs, procedures, and functions outside the package. For example, if you have access to the package, you can create a procedure increase_all_comms separate from the emp_mgmt package that calls the increase_comm procedure.

These objects are defined in the package body, so you can change their definitions without causing Oracle Database to invalidate dependent schema objects. For example, if you subsequently change the definition of hire, then the database need not recompile increase_all_comms before executing it.

The package body in this example also declares private program objects, the variables tot_emps and tot_depts. These objects are declared in the package body rather than the package specification, so they are accessible to other objects in the package, but they are not accessible outside the package. For example, you cannot develop an application that explicitly changes the value of the variable tot_depts. However, the function create_dept is part of the package, so create_dept can change the value of tot_depts.