AnyData Class

The AnyData class models self-descriptive data by encapsulating the type information with the actual data. AnyData is used primarily with OCCI Advanced Queuing feature, to represent and enqueue data and to receive messages from queues as AnyData instances.

Most SQL and user-defined types can be converted into an AnyData type using the setFromxxx() methods. An AnyData object can be converted into most SQL and user-defined types using getAsxxx() methods. SYS.ANYDATA type models AnyData both in SQL and PL/SQL. See Table 13-4, "OCCI Data Types supported by AnyData Class" for supported data types.

The getType() call returns the TypeCode represented by an AnyData object, while the isNull() call determines if AnyData contains a NULL value. The setNull() method sets the value of AnyData to NULL.

To use the OCCI AnyData type, the environment has to be initiated in OBJECT mode.

Connection *conn;
...
AnyData any(conn);
string str("Hello World");
any.setFromString(str);
...

Connection *conn;
string str;
...
if(!any.isNULL())
{   if(any.getType()==OCCI_TYPECODE_VARCHAR2)
   {
      str = any.getAsString();
      cout<<str;
   }
}
...

Connection *conn;
...
// Assume an OBJECT of type Person with the following defined fields
// CREATE TYPE person as OBJECT (
//    FRIST_NAME VARCHAR2(20),
//    LAST_NAME VARCHAR2(25),
//    EMAIL VARCHAR2(25),
//    SALARY NUMBER(8,2)
//   );
// Assume relevant classes have been generated by OTT.
...
Person *pers new Person( "Steve", "Addams",
                         "steve.addams@anycompany.com", 50000.00);
AnyData anyObj(conn);
anyObj.setFromObject(pers);
...

Connection *conn;
// Assume an OBJECT of type Person with the following defined fields
// CREATE TYPE person as OBJECT (
//    FRIST_NAME VARCHAR2(20),
//    LAST_NAME VARCHAR2(25),
//    EMAIL VARCHAR2(25),
//    SALARY NUMBER(8,2)
//   );
// Assume relevant classes have been generated by OTT.
Person *pers = new Person();
...
If(!anyObj.isNull())
{   if(anyObj.getType()==OCCI_TYPECODE_OBJECT)
      pers = anyObj.getAsObject();
}
...

BDouble

OCCI_TYPECODE_BDOUBLE

BFile

OCCI_TYPECODE_BFILE

BFloat

OCCI_TYPECODE_BFLOAT

Bytes

OCCI_TYPECODE_RAW

Date

OCCI_TYPECODE_DATE

IntervalDS

OCCI_TYPECODE_INTERVAL_DS

IntervalYM

OCCI_TYPECODE_INTERVAL_YM

Number

OCCI_TYPECODE_NUMBERB

PObject

OCCI_TYPECODE_OBJECT

Ref

OCCI_TYPECODE_REF

string

OCCI_TYPECODE_VARCHAR2

TimeStamp

OCCI_TYPECODE_TIMESTAMP

AnyData()

AnyData constructor.

LNCPP20538Syntax

AnyData(
   const Connection *conn); 

conn

getAsBDouble()

Converts an AnyData object into BDouble.

LNCPP20540Syntax

BDouble getAsBDouble() const;

getAsBfile()

Converts an AnyData object into Bfile.

LNCPP20542Syntax

Bfile getAsBfile() const;

getAsBFloat()

Converts an AnyData object into BFloat.

LNCPP20544Syntax

BFloat getAsBFloat() const;

getAsBytes()

Converts an AnyData object into Bytes.

LNCPP20546Syntax

Bytes getAsBytes() const;

getAsDate()

Converts an AnyData object into Date.

LNCPP20548Syntax

Date getAsDate() const;

getAsIntervalDS()

Converts an AnyData object into IntervalDS.

LNCPP20550Syntax

IntervalDS getAsIntervalDS() const;

getAsIntervalYM()

Converts an AnyData object into IntervalYM.

LNCPP20552Syntax

IntervalYS getAsIntervalYM() const;

getAsNumber()

Converts an AnyData object into Number.

LNCPP20554Syntax

Number getAsNumber() const;

getAsObject()

Converts an AnyData object into PObject.

LNCPP20556Syntax

PObject* getAsObject() const;

getAsRef()

Converts an AnyData object into RefAny.

LNCPP20558Syntax

RefAny getAsRef() const;

getAsString()

Converts an AnyData object into a namespace string.

LNCPP20560Syntax

string getAsString() const;

getAsTimestamp()

Converts an AnyData object into Timestamp.

LNCPP20562Syntax

Timestamp getAsTimestamp() const;

getType()

Retrieves the data type held by the AnyData object. Refer to Table 13-4 for valid values for TypeCode.

LNCPP20564Syntax

TypeCode getType();

isNull()

Tests whether the AnyData object is NULL. If the AnyData object is NULL, then TRUE is returned; otherwise, FALSE is returned.

LNCPP20566Syntax

bool isNull() const;

setFromBDouble()

Converts a BDouble into AnyData.

LNCPP20568Syntax

void setFromBDouble(
   const BDouble& bdouble);

bdouble

setFromBfile()

Converts a Bfile into AnyData.

LNCPP20570Syntax

void setFromBfile(
   const Bfile& bfile);

bfile

setFromBFloat()

Converts a BFloat into AnyData.

LNCPP20572Syntax

void setFromBFloat(
   const BFloat& bfloat);

bfloat

setFromBytes()

Converts a Bytes into AnyData.

LNCPP20574Syntax

void setFromBytes(
   const Bytes& bytes);

bytes

setFromDate()

Converts a Date into AnyData.

LNCPP20576Syntax

void setFromDate(
   const Date& date);

date

setFromIntervalDS()

Converts an IntervalDS into AnyData.

LNCPP20578Syntax

void setFromIntervalDS(
   const IntervalDS& intervalds);

invtervalds

setFromIntervalYM()

Converts an IntervalYM into AnyData.

LNCPP20580Syntax

void setFromIntervalYM(
   const IntervalYM& intervalym);

invalym

setFromNumber()

Converts a Number into AnyData.

LNCPP20582Syntax

void setFromNumber(
   const Number& num);

num

setFromObject()

Converts a PObject into AnyData.

LNCPP20584Syntax

void setFromObject(
   const PObject* objptr);

objptr

setFromRef()

Converts a PObject into AnyData.

LNCPP20586Syntax

void setFromRef(
   const RefAny& ref
   const string &typeName,
   const string &schema);

ref

typeName

schema

setFromString()

Converts a namespace string into AnyData.

LNCPP20588Syntax

void setFromString(
   string& str);

str

setFromTimestamp()

Converts a Timestamp into AnyData.

LNCPP20590Syntax

void setFromTimestamp(
   const Timestamp& timestamp);

timestamp

setNull()

Sets AnyData object to NULL.

LNCPP20592Syntax

void setNull();