René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

anytype, anydata and anydataset [Oracle]

anytype, anydata and anydataset are used to dynamically create object types and instances theirof. Dynamically because they're created without a create type statement.
Such a creation is usually a two step process: first, the type itself is created with anytype's methods. Then, instances of such types are created with anydata's and anydataset's methods.
Alternatively, an (anydata) instance can also be created with anydata's convertXXX methods, such as anydata.convertnumber. This is demonstrated in this example.

anydata

The following convertXXX methods create an anydata instance from an already existing type. For example, convertnumber creates an anydata instance from a number.

STATIC FUNCTION CONVERTNUMBER RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NUM                            NUMBER                  IN

STATIC FUNCTION CONVERTDATE RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
DAT                            DATE                    IN

STATIC FUNCTION CONVERTCHAR RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              CHAR                    IN

STATIC FUNCTION CONVERTVARCHAR RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              VARCHAR2                IN

STATIC FUNCTION CONVERTVARCHAR2 RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              VARCHAR2                IN

STATIC FUNCTION CONVERTRAW RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
R                              RAW                     IN

STATIC FUNCTION CONVERTBLOB RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
B                              BLOB                    IN

STATIC FUNCTION CONVERTCLOB RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              CLOB                    IN

STATIC FUNCTION CONVERTBFILE RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
B                              BINARY FILE LOB         IN

STATIC FUNCTION CONVERTOBJECT RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
OBJ                            UNDEFINED               IN

STATIC FUNCTION CONVERTOBJECT RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
OBJ                            UNDEFINED               IN

STATIC FUNCTION CONVERTREF RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
RF                             UNDEFINED               IN

STATIC FUNCTION CONVERTCOLLECTION RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
COL                            UNDEFINED               IN

STATIC PROCEDURE BEGINCREATE

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
DTYPE                          ANYTYPE                 IN/OUT NOCOPY
ADATA                          ANYDATA                 OUT NOCOPY

MEMBER PROCEDURE PIECEWISE

MEMBER PROCEDURE SETNUMBER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NUM                            NUMBER                  IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETDATE

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
DAT                            DATE                    IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETCHAR

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              CHAR                    IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETVARCHAR

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              VARCHAR2                IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETVARCHAR2

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              VARCHAR2                IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETRAW

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
R                              RAW                     IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETBLOB

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
B                              BLOB                    IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETCLOB

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              CLOB                    IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETBFILE

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
B                              BINARY FILE LOB         IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETOBJECT

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
OBJ                            UNDEFINED               IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETOBJECT

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
OBJ                            UNDEFINED               IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETREF

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
RF                             UNDEFINED               IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETCOLLECTION

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
COL                            UNDEFINED               IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE ENDCREATE

MEMBER FUNCTION GETTYPENAME RETURNS VARCHAR2

MEMBER FUNCTION GETTYPE RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TYP                            ANYTYPE                 OUT NOCOPY

MEMBER FUNCTION GETNUMBER RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NUM                            NUMBER                  OUT NOCOPY

MEMBER FUNCTION GETDATE RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
DAT                            DATE                    OUT NOCOPY

MEMBER FUNCTION GETCHAR RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              CHAR                    OUT NOCOPY

MEMBER FUNCTION GETVARCHAR RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              VARCHAR2                OUT NOCOPY

MEMBER FUNCTION GETVARCHAR2 RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              VARCHAR2                OUT NOCOPY

MEMBER FUNCTION GETRAW RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
R                              RAW                     OUT NOCOPY

MEMBER FUNCTION GETBLOB RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
B                              BLOB                    OUT NOCOPY

MEMBER FUNCTION GETCLOB RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              CLOB                    OUT NOCOPY

MEMBER FUNCTION GETBFILE RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
B                              BINARY FILE LOB         OUT NOCOPY

MEMBER FUNCTION GETOBJECT RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
OBJ                            UNDEFINED               OUT NOCOPY

MEMBER FUNCTION GETOBJECT RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
OBJ                            UNDEFINED               OUT NOCOPY

MEMBER FUNCTION GETREF RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
RF                             UNDEFINED               OUT NOCOPY

MEMBER FUNCTION GETCOLLECTION RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
COL                            UNDEFINED               OUT NOCOPY

STATIC FUNCTION CONVERTTIMESTAMP RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP               IN

STATIC FUNCTION CONVERTTIMESTAMPTZ RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP WITH TIME ZONE IN

STATIC FUNCTION CONVERTTIMESTAMPLTZ RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP WITH LOCAL TIME ZONE IN

STATIC FUNCTION CONVERTINTERVALYM RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
INV                            INTERVAL YEAR TO MONTH  IN

STATIC FUNCTION CONVERTINTERVALDS RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
INV                            INTERVAL DAY TO SECOND  IN

STATIC FUNCTION CONVERTNCHAR RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NCHAR                   IN

STATIC FUNCTION CONVERTNVARCHAR2 RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NVARCHAR2               IN

STATIC FUNCTION CONVERTNCLOB RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NCLOB                   IN

MEMBER PROCEDURE SETTIMESTAMP

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP               IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETTIMESTAMPTZ

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP WITH TIME ZONE IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETTIMESTAMPLTZ

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP WITH LOCAL TIME ZONE IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETINTERVALYM

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
INV                            INTERVAL YEAR TO MONTH  IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETINTERVALDS

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
INV                            INTERVAL DAY TO SECOND  IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETNCHAR

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NCHAR                   IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETNVARCHAR2

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NVARCHAR2               IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETNCLOB

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NCLOB                   IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER FUNCTION GETTIMESTAMP RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP               OUT NOCOPY

MEMBER FUNCTION GETTIMESTAMPTZ RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP WITH TIME ZONE OUT NOCOPY

MEMBER FUNCTION GETTIMESTAMPLTZ RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP WITH LOCAL TIME ZONE OUT NOCOPY

MEMBER FUNCTION GETINTERVALYM RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
INV                            INTERVAL YEAR TO MONTH  IN/OUT NOCOPY

MEMBER FUNCTION GETINTERVALDS RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
INV                            INTERVAL DAY TO SECOND  IN/OUT NOCOPY

MEMBER FUNCTION GETNCHAR RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NCHAR                   OUT NOCOPY

MEMBER FUNCTION GETNVARCHAR2 RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NVARCHAR2               OUT NOCOPY

MEMBER FUNCTION GETNCLOB RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NCLOB                   OUT NOCOPY

MEMBER FUNCTION ACCESSNUMBER RETURNS NUMBER

MEMBER FUNCTION ACCESSDATE RETURNS DATE

MEMBER FUNCTION ACCESSCHAR RETURNS CHAR

MEMBER FUNCTION ACCESSVARCHAR RETURNS VARCHAR2

MEMBER FUNCTION ACCESSVARCHAR2 RETURNS VARCHAR2

MEMBER FUNCTION ACCESSRAW RETURNS RAW

MEMBER FUNCTION ACCESSBLOB RETURNS BLOB

MEMBER FUNCTION ACCESSCLOB RETURNS CLOB

MEMBER FUNCTION ACCESSBFILE RETURNS BINARY FILE LOB

MEMBER FUNCTION ACCESSTIMESTAMP RETURNS TIMESTAMP

MEMBER FUNCTION ACCESSTIMESTAMPTZ RETURNS TIMESTAMP WITH TIME ZONE

MEMBER FUNCTION ACCESSTIMESTAMPLTZ RETURNS TIMESTAMP WITH LOCAL TIME ZONE

MEMBER FUNCTION ACCESSINTERVALYM RETURNS INTERVAL YEAR TO MONTH

MEMBER FUNCTION ACCESSINTERVALDS RETURNS INTERVAL DAY TO SECOND

MEMBER FUNCTION ACCESSNCHAR RETURNS NCHAR

MEMBER FUNCTION ACCESSNVARCHAR2 RETURNS NVARCHAR2

MEMBER FUNCTION ACCESSNCLOB RETURNS NCLOB

STATIC FUNCTION CONVERTBFLOAT RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
FL                             BINARY_FLOAT            IN

STATIC FUNCTION CONVERTBDOUBLE RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
DBL                            BINARY_DOUBLE           IN

STATIC FUNCTION CONVERTUROWID RETURNS ANYDATA

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
RID                            ROWID                   IN

MEMBER PROCEDURE SETBFLOAT

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
FL                             BINARY_FLOAT            IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETBDOUBLE

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
DBL                            BINARY_DOUBLE           IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER FUNCTION GETBFLOAT RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
FL                             BINARY_FLOAT            OUT NOCOPY

MEMBER FUNCTION GETBDOUBLE RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
DBL                            BINARY_DOUBLE           OUT NOCOPY

MEMBER FUNCTION ACCESSBFLOAT RETURNS BINARY_FLOAT

MEMBER FUNCTION ACCESSBDOUBLE RETURNS BINARY_DOUBLE

MEMBER FUNCTION ACCESSUROWID RETURNS ROWID

anytype

STATIC PROCEDURE BEGINCREATE

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TYPECODE                       PLS_INTEGER             IN    
ATYPE                          ANYTYPE                 OUT NOCOPY
This procedure must be called in order to create an anytype. The parameter typecode can be one of the constants defined in dbms_types.
If typecode is dbms_types.typecode_object, then the attributes (or members) of the object can be added with addattr.

MEMBER PROCEDURE SETINFO

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
PREC                           PLS_INTEGER             IN    
SCALE                          PLS_INTEGER             IN    
LEN                            PLS_INTEGER             IN    
CSID                           PLS_INTEGER             IN    
CSFRM                          PLS_INTEGER             IN    
ATYPE                          ANYTYPE                 IN     DEFAULT
ELEM_TC                        PLS_INTEGER             IN     DEFAULT
ELEM_COUNT                     PLS_INTEGER             IN     DEFAULT

MEMBER PROCEDURE ADDATTR

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
ANAME                          VARCHAR2                IN    
TYPECODE                       PLS_INTEGER             IN    
PREC                           PLS_INTEGER             IN    
SCALE                          PLS_INTEGER             IN    
LEN                            PLS_INTEGER             IN    
CSID                           PLS_INTEGER             IN    
CSFRM                          PLS_INTEGER             IN    
ATTR_TYPE                      ANYTYPE                 IN     DEFAULT
This method adds an attribute to an instance of anytype that was created with anytype.begincreate and with typecode dbms_types.typecode_object.

MEMBER PROCEDURE ENDCREATE

Ends the creation of an anytype. endcreate can only be called after anytype.begincreate was called. After calling endcreate no other methods can be called on an anytype instance.

STATIC FUNCTION GETPERSISTENT RETURNS ANYTYPE

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
SCHEMA_NAME                    VARCHAR2                IN    
TYPE_NAME                      VARCHAR2                IN    
VERSION                        VARCHAR2                IN     DEFAULT

MEMBER FUNCTION GETINFO RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
PREC                           PLS_INTEGER             OUT   
SCALE                          PLS_INTEGER             OUT   
LEN                            PLS_INTEGER             OUT   
CSID                           PLS_INTEGER             OUT   
CSFRM                          PLS_INTEGER             OUT   
SCHEMA_NAME                    VARCHAR2                OUT   
TYPE_NAME                      VARCHAR2                OUT   
VERSION                        VARCHAR2                OUT   
COUNT                          PLS_INTEGER             OUT

MEMBER FUNCTION GETATTRELEMINFO RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
POS                            PLS_INTEGER             IN    
PREC                           PLS_INTEGER             OUT   
SCALE                          PLS_INTEGER             OUT   
LEN                            PLS_INTEGER             OUT   
CSID                           PLS_INTEGER             OUT   
CSFRM                          PLS_INTEGER             OUT   
ATTR_ELT_TYPE                  ANYTYPE                 OUT   
ANAME                          VARCHAR2                OUT

anydataset

anydataset can be thought of an array of elements that share the same data type. The data type can be an Oracle built in data type or a user defined one.

STATIC PROCEDURE BEGINCREATE

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TYPECODE                       PLS_INTEGER             IN    
RTYPE                          ANYTYPE                 IN/OUT NOCOPY
ASET                           ANYDATASET              OUT NOCOPY

MEMBER PROCEDURE ADDINSTANCE

Adds a new instance to a anydataset.

MEMBER PROCEDURE PIECEWISE

MEMBER PROCEDURE SETNUMBER

) 
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NUM                            NUMBER                  IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETDATE

, anchor=>'anydataset_setdate') 
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
DAT                            DATE                    IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETCHAR

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              CHAR                    IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETVARCHAR

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              VARCHAR2                IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETVARCHAR2

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              VARCHAR2                IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETRAW

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
R                              RAW                     IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETBLOB

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
B                              BLOB                    IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETCLOB

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              CLOB                    IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETBFILE

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
B                              BINARY FILE LOB         IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETOBJECT

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
OBJ                            UNDEFINED               IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETOBJECT

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
OBJ                            UNDEFINED               IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETREF

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
RF                             UNDEFINED               IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETCOLLECTION

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
COL                            UNDEFINED               IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE ENDCREATE

MEMBER FUNCTION GETTYPENAME RETURNS VARCHAR2

MEMBER FUNCTION GETTYPE RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TYP                            ANYTYPE                 OUT NOCOPY

MEMBER FUNCTION GETINSTANCE RETURNS PLS_INTEGER

MEMBER FUNCTION GETNUMBER RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NUM                            NUMBER                  OUT NOCOPY

MEMBER FUNCTION GETDATE RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
DAT                            DATE                    OUT NOCOPY

MEMBER FUNCTION GETCHAR RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              CHAR                    OUT NOCOPY

MEMBER FUNCTION GETVARCHAR RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              VARCHAR2                OUT NOCOPY

MEMBER FUNCTION GETVARCHAR2 RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              VARCHAR2                OUT NOCOPY

MEMBER FUNCTION GETRAW RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
R                              RAW                     OUT NOCOPY

MEMBER FUNCTION GETBLOB RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
B                              BLOB                    OUT NOCOPY

MEMBER FUNCTION GETCLOB RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
C                              CLOB                    OUT NOCOPY

MEMBER FUNCTION GETBFILE RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
B                              BINARY FILE LOB         OUT NOCOPY

MEMBER FUNCTION GETOBJECT RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
OBJ                            UNDEFINED               OUT NOCOPY

MEMBER FUNCTION GETOBJECT RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
OBJ                            UNDEFINED               OUT NOCOPY

MEMBER FUNCTION GETREF RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
RF                             UNDEFINED               OUT NOCOPY

MEMBER FUNCTION GETCOLLECTION RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
COL                            UNDEFINED               OUT NOCOPY

MEMBER FUNCTION GETCOUNT RETURNS PLS_INTEGER

MEMBER PROCEDURE SETTIMESTAMP

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP               IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETTIMESTAMPTZ

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP WITH TIME ZONE IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETTIMESTAMPLTZ

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP WITH LOCAL TIME ZONE IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETINTERVALYM

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
INV                            INTERVAL YEAR TO MONTH  IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETINTERVALDS

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
INV                            INTERVAL DAY TO SECOND  IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETNCHAR

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NCHAR                   IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETNVARCHAR2

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NVARCHAR2               IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETNCLOB

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NCLOB                   IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER FUNCTION GETTIMESTAMP RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP               OUT NOCOPY

MEMBER FUNCTION GETTIMESTAMPTZ RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP WITH TIME ZONE OUT NOCOPY

MEMBER FUNCTION GETTIMESTAMPLTZ RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
TS                             TIMESTAMP WITH LOCAL TIME ZONE OUT NOCOPY

MEMBER FUNCTION GETINTERVALYM RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
INV                            INTERVAL YEAR TO MONTH  IN/OUT NOCOPY

MEMBER FUNCTION GETINTERVALDS RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
INV                            INTERVAL DAY TO SECOND  IN/OUT NOCOPY

MEMBER FUNCTION GETNCHAR RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NCHAR                   OUT NOCOPY

MEMBER FUNCTION GETNVARCHAR2 RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NVARCHAR2               OUT NOCOPY

MEMBER FUNCTION GETNCLOB RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
NC                             NCLOB                   OUT NOCOPY

MEMBER PROCEDURE SETBFLOAT

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
FL                             BINARY_FLOAT            IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETBDOUBLE

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
DBL                            BINARY_DOUBLE           IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER PROCEDURE SETUROWID

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
RID                            ROWID                   IN    
LAST_ELEM                      BOOLEAN                 IN     DEFAULT

MEMBER FUNCTION GETBFLOAT RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
FL                             BINARY_FLOAT            OUT NOCOPY

MEMBER FUNCTION GETBDOUBLE RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
DBL                            BINARY_DOUBLE           OUT NOCOPY

MEMBER FUNCTION GETUROWID RETURNS PLS_INTEGER

Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
RID                            ROWID                   OUT NOCOPY

Links

Other datatypes