Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
SQL Statements (continued), 4 of 10
procedure_declaration | function_declaration::=
Java_declaration::=
C_declaration::=
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. The CREATE
TYPE
statement specifies the name of the object type, its attributes, methods, and other properties. The CREATE
TYPE
BODY
statement contains the code for the methods in the type.
For each method specified in an object type specification for which you did not specify the call_spec, you must specify a corresponding method body in the object type body.
For information on creating and modifying a type specification, see "CREATE TYPE" and "ALTER TYPE".
Every member declaration in the CREATE
TYPE
specification for object types must have a corresponding construct in the CREATE
TYPE
or CREATE
TYPE
BODY
statement.
To create or replace a type body in your own schema, you must have the CREATE
TYPE
or the CREATE
ANY
TYPE
system privilege. To create an object type in another user's schema, you must have the CREATE
ANY
TYPE
system privileges. To replace an object type in another user's schema, you must have the DROP
ANY
TYPE
system privileges.
|
re-creates the type body if it already exists. Use this clause to change the definition of an existing type body without first dropping it. |
|
|
Users previously granted privileges on the re-created object type body can use and reference the object type body without being granted privileges again. |
|
|
You can use this clause to add new member subprogram definitions to specifications added with the |
|
schema |
is the schema to contain the type body. If you omit schema, Oracle creates the type body in your current schema. |
|
type_name |
is the name of an object type. |
|
|
declares or implements a method function or procedure subprogram associated with the object type specification. For a description of the difference between member and static methods, see "CREATE TYPE". For information about overloading subprogram names within a package, see PL/SQL User's Guide and Reference. |
|
|
You must define a corresponding method name, optional parameter list, and (for functions) a return type in the object type specification for each procedure or function declaration. |
|
|
procedure_declaration |
is the declaration of a procedure subprogram. |
|
function_declaration |
is the declaration of a function subprogram. |
|
See Also: "CREATE PROCEDURE", "CREATE FUNCTION", and Oracle8i Application Developer's Guide - Fundamentals. |
|
|
declares or implements a member function ( |
|
|
If the argument to the map method is null, the map method returns null and the method is not invoked. |
|
|
An object type body can contain only one map method, which must be a function. The map function can have no arguments other than the implicit |
|
|
specifies a member function ( |
|
|
If either argument to the order method is null, the order method returns null and the method is not invoked.
When instances of the same object type definition are compared in an |
|
|
An object specification can contain only one |
|
You can declare either a |
||
If you do not declare either method, you can compare object instances only for equality or inequality. Instances of the same type definition are equal only if each pair of their corresponding attributes is equal. |
||
procedure_declaration | function_declaration |
is the declaration of a procedure or function subprogram. The |
|
|
pl/sql_block |
declares the procedure or function. See Also: PL/SQL User's Guide and Reference. |
|
call_spec |
is the call specification ("call spec") that maps a Java or C method name, parameter types, and return type to their SQL counterparts. In Java_declaration, 'string' identifies the Java implementation of the method. See Also:
|
|
AS EXTERNAL |
is an alternative way of declaring a C method. This clause has been deprecated and is supported for backward compatibility only. Oracle Corporation recommends that you use the call_spec syntax with the C_declaration. |
The following object type body implements member subprograms for RATIONAL
.
CREATE TYPE BODY rational IS MAP MEMBER FUNCTION rat_to_real RETURN REAL IS BEGIN RETURN numerator/denominator; END; MEMBER PROCEDURE normalize IS gcd NUMBER := integer_operations.greatest_common_divisor (numerator, denominator); BEGIN numerator := numerator/gcd; denominator := denominator/gcd; END; MEMBER FUNCTION plus(x rational) RETURN rational IS r rational := rational_operations.make_rational (numerator*x.denominator + x.numerator*denominator, denominator*x.denominator); BEGIN RETURN r; END; END;
|
Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|