Skip navigation links

org.eclipse.persistence.platform.database.oracle.annotations
Annotation Type PLSQLTable

@Target(value=TYPE)
@Retention(value=RUNTIME)
public @interface PLSQLTable

A PLSQLTable annotation is used to define a database PLSQL TABLE type. This type can be used within PLSQL procedure calls.

Since:

EclipseLink 2.3

Author:

James Sutherland

See Also:

NamedPLSQLStoredProcedureQuery

Required Element Summary

java.lang.String	compatibleType (Required) The name of the database VARRAY type that mirrors the table's structure.
java.lang.String	name (Required) The name of the record type in the database.

Optional Element Summary

java.lang.Class	javaType (Optional) The Java Collection class to map the varray to.
java.lang.String	nestedType (Required) The name of the database OBJECT TYPE or VARRAY type that mirrors the record's structure.

Element Detail

name

public abstract java.lang.String name

(Required) The name of the record type in the database.

compatibleType

public abstract java.lang.String compatibleType

(Required) The name of the database VARRAY type that mirrors the table's structure. The table will be converted to/from this type so it can be passed through JDBC.

nestedType

public abstract java.lang.String nestedType

(Required) The name of the database OBJECT TYPE or VARRAY type that mirrors the record's structure. The record will be converted to/from this type so it can be passed through JDBC.

Default:

"VARCHAR_TYPE"

javaType

public abstract java.lang.Class javaType

(Optional) The Java Collection class to map the varray to. This can be any valid Collection implementation.

Default:

java.util.ArrayList.class

Skip navigation links