Oracle9i Supplied PL/SQL Packages and Types Reference
Release 1 (9.0.1)

Part Number A89852-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to next page

87
ANYTYPE TYPE

An ANYTYPE can contain a type description of any persistent SQL type, named or unnamed, including object types and collection types. It can also be used to construct new transient type descriptions.

New persistent types can only be created using the CREATE TYPE statement. Only new transient types can be constructed using the ANYTYPE interfaces.

Thios chapter discusses the following:

Summary of ANYTYPE Subprograms

Table 87-1 ANYTYPE Subprograms
Subprogram  Description 

"BEGINCREATE Static Procedure" 

Creates a new instance of ANYTYPE which can be used to create a transient type description. 

"SETINFO Member Procedure" 

Sets any additional information required for constructing a COLLECTION or builtin type. 

"ADDATTR Member Procedure" 

Adds an attribute to an ANYTYPE (of typecode DBMS_TYPES.TYPECODE_OBJECT). 

"ENDCREATE Member Procedure" 

Ends creation of a transient AnyType. Other creation functions cannot be called after this call. 

"GETPERSISTENT Static Function" 

Returns an AnyType corresponding to a persistent type created earlier using the CREATE TYPE SQL statement. 

"GETINFO Member Function" 

Gets the type information for the AnyType. 

"GETATTRELEMINFO Member Function" 

Gets the type information for an attribute of the type (if it is of TYPECODE_OBJECT). Gets the type information for a collection's element type if the self parameter is of a collection type. 


Go to previous page Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback