You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. Then for a category with search results, click Select to choose your product and release filters, and then click OK.

For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"

How do I find the documentation for my product or service?

From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:

  • Click the Find a product tab and search for your product or service.
  • Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
  • Apple Safari: Version 6
  • Google Chrome: Version 29 and later
  • Mozilla Firefox: Version 24 and later
  • Microsoft Internet Explorer: Version 9 and later
Results for BODY


1 to 20 of 713 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Reference Guide for Microsoft SQL Server and Sybase Adaptive Server Migrations, 9i Release 2 (9.2.0.2)

Triggers and Stored Procedures

Package BodyThis section provides the following tables for the schema object Package Body: Create Drop Alter … Create Table 3-13 Comparison of Creating the Package Body Schema Object in Oracle and Microsoft SQL … REPLACE] PACKAGE BODY [schema.]package {IS | AS} pl/sql_package_body N/A Description: This is the … internal or private part of

Dynamic Services User's and Administrator's Guide, 9i Release 2 (9.2.0.2)

Service Development Guide

6.3.2 Service Body SectionThe service body section contains more detailed descriptions and information used by the Dynamic … . 6.3.2.1 Input Handling and Adaptor Specifications The service body section has input specifications

Performance Tuning Guide and Reference, 9i Release 2 (9.2.0.2)

Using SQL Trace and TKPROF

Sample TKPROF BodyALTER SESSION SET SQL_TRACE = true call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.10 0 0 0 0 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 1 0.00 0.10 0 0 0 0 Misses in library cache during parse: 0 Misses in library

Application Developer's Guide - Fundamentals, 9i Release 2 (9.2.0.2)

Using Triggers

Coding the Trigger BodyThe trigger body is a CALL procedure or a PL/SQL block that can include SQL and PL/SQL statements … (if included) evaluates to TRUE. The trigger body for row triggers has some special constructs that

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE LIBRARY to CREATE SPFILE, 8 of 16

CREATE PACKAGE BODYPurpose Use the CREATE PACKAGE BODY statement to create the body of a stored package, which is an … together in the database. The body defines these objects. Packages are an alternative to creating

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: CREATE TYPE to DROP ROLLBACK SEGMENT, 3 of 26

CREATE TYPE BODYPurpose Use the CREATE TYPE BODY to define or implement the member methods defined in the object … type specification. You create object types with the CREATE TYPE and the CREATE TYPE BODY statements … properties. The CREATE TYPE BODY statement contains the code for the methods in the type. For each … must specify a corresponding

Reference Guide for Microsoft SQL Server and Sybase Adaptive Server Migrations, 9i Release 2 (9.2.0.2)

Migrating Temporary Tables to Oracle

Package Body t_tablecreate or replace PACKAGE BODY t_table IS last_table varchar2(30):=. -- Store the last used

User's Guide and Reference, 9i Release 2 (9.2.0.2)

PL/SQL Packages

Understanding The Package BodyThe package body implements the package spec. That is, the package body contains the implementation … in a package body are accessible outside the package only if their specs also appear in the package … (date_hired emp.hiredate%TYPE,...); END emp_actions; CREATE PACKAGE BODY emp_actions AS... PROCEDURE … ' --

Data Cartridge Developer's Guide, 9i Release 2 (9.2.0.2)

What Is a Data Cartridge?

Object Type Body CodeThe type body provides the code that implements the object type's methods. Method code can be

SQL Reference, 9i Release 2 (9.2.0.2)

SQL Statements: DROP SEQUENCE to ROLLBACK, 8 of 19

DROP TYPE BODYPurpose Use the DROP TYPE BODY statement to drop the body of an object type, varray, or nested … table type. When you drop a type body, the object type specification still exists, and you can re-create … the type body. Prior to re-creating the body, you can still use the object type, although you

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05809 Error: vppinetrs conncect_req body readCause: error during recovery of State file Action: Restart the Data Gatherer. If the problem still exists, contact Oracle Support Services.

Application Developer's Guide - Advanced Queuing, 9i Release 2 (9.2.0.2)

JMS and AQ XML Servlet Error Messages

JMS-411 Payload body cannot be nullCause: An invalid body string or document was specified Action: Specify a non- body string or document for the payload

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05803 Error: read error on first record bodyCause: the first record in the State file is corrupt Action: the state file will need to be deleted. Save a copy, and contact Oracle Support Services. In the meantime you can reconnect to the service through Capacity Planner and set up collections again.

Messages Manual, 9i Release 2 (9.2.0.2)

Oracle Data Collection Service Messages (Second Tier)

ODG-05839 Error: body of file read failedCause: the state file is corrupt. Action: the state file will need to be deleted. Save a copy, and contact Oracle Support Services. In the meantime you can reconnect to the service through Capacity Planner and set up collections again.

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0550 Usage: SHOW ERRORS FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER | VIEW | TYPE |…Cause: Incorrect syntax for the SHOW ERRORS command was entered. Action: Check the syntax of the SHOW ERRORS command for the correct options.

Application Developer's Guide - Workspace Manager, 9i Release 2 (9.2.0.2)

Error Messages

WM_ERROR_178 user-defined trigger body defined on 'string'. 'string' exceeds 28000 charactersbody length of more than 28000 characters defined on it. Action: Ensure that all user defined … triggers on the table to be version-enabled have trigger body lengths that are less than 28000 characters.

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0281 option_name missing set option Usage: SET SHIFTINOUT VISIBLE|INVISIBLE SET MARKUP HTML ON|OFF…Cause: SET option was missing in the command. Action: Check the syntax of the command you used for the correct options.

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Error Messages

SP2-0858 Usage: SET MARKUP HTML HEAD text BODY text TABLE text ENTMAP {ON|OFFPREFORMAT {ON|OFFCause: An invalid option to SET MARKUP was entered in i SQL*Plus. Action: Remove the invalid option.

SQL*Plus® User's Guide and Reference, 9i Release 2 (9.2.0.2)

SQL*Plus Command Reference

SET MARKUP HTML ON| OFF HEAD text BODY text TABLE text ENTMAP { ON |OFFSPOOL {ON| OFF PREFORMAT {ON|…generate invalid HTML output in i SQL*Plus as it may corrupt the browser screen. The HEAD and BODY

Error Messages, 9i Release 2 (9.2.0.2)

SQL*Module Messages (MOD)

MOD-00083 [package body compiled]Cause: This is an informational message. Action: No action is required.