Oracle Tip: Serialise data with ANYDATA columns

July 30, 2004

[From Builder UK]

Oracle version 9 introduced interesting new data types, which allow developers to declare a variable that can contain any type of data. The data types are ANYDATA for a single item, ANYDATASET for a TABLE or VARRAY of data, and ANYTYPE, which describes the type of data stored in ANYDATA or ANYDATASET variables and columns. These data types are important for processing XML data stored in the database, or for Advanced Queues. The documentation mentions that the ANYDATA data type can be used to serialize objects, but there are very few examples of this concept.

The article continues at http://uk.builder.com/architecture/db/0,39026552,39213578,00.htm