CREATE TYPE BODY

The CREATE TYPE BODY statement defines or implements the member methods in the type specification created by the CREATE TYPE statement.

For methods not specified in the call_spec of the type specification, you must specify the method body in the type body.

Prerequisites

In the CREATE TYPE statement of an ADT, each member declaration must have a corresponding constructor in the CREATE TYPE or CREATE TYPE BODY statement.

To create or replace a type body in a schema, you must have the CREATE TYPE or CREATE ANY TYPE system privilege. To create a type in another user's schema, you must have the CREATE ANY TYPE system privilege. To replace a type in another user's schema, you must have the DROP ANY TYPE system privilege.

Syntax

• The syntax of create_type_body_stmt is as follows:

  

• The syntax of plsql_type_body_source is as follows:

  

• The syntax of plsql_type_body_decl_list_semicolon is as follows:

  

• The syntax of plsql_type_body_decl_list is as follows:

  

• The syntax of proc_or_func_def_in_type is as follows:

  

Semantics

Examples

CREATE TYPE demo_typ2 AS OBJECT (
     a1 NUMBER,
     MEMBER FUNCTION get_square RETURN NUMBER
   );
/

CREATE OR REPLACE TYPE BODY demo_typ2 IS
     MEMBER FUNCTION get_square RETURN NUMBER IS
     BEGIN
        RETURN a1;
    END;
  END;
/