org.eclipse.persistence.platform.database.oracle.annotations

Annotation Type PLSQLParameter

@Target(value={})
@Retention(value=RUNTIME)
public @interface PLSQLParameter

A PLSQLParameter annotation is used within a NamedPLSQLStoredProcedureQuery or PLSQLRecord annotation.

See Also:

NamedPLSQLStoredProcedureQuery, PLSQLRecord

Author:

James Sutherland

Since:

EclipseLink 2.3

Required Element Summary

Required Elements

Modifier and Type	Required Element and Description
java.lang.String	name (Required) Stored procedure parameter name.

Optional Element Summary

Optional Elements

Modifier and Type	Optional Element and Description
java.lang.String	databaseType (Optional) The database data-type for the paramter.
Direction	direction (Optional) The direction of the stored procedure parameter.
int	length (Optional) The max length of the field value.
boolean	optional (Optional) Define if the parameter is required, or optional and defaulted by the procedure.
int	precision (Optional) If a numeric, the max precision value.
java.lang.String	queryParameter (Optional) The query parameter name.
int	scale (Optional) If a numeric, the max scale value.

Element Detail

name

public abstract java.lang.String name

(Required) Stored procedure parameter name.

direction

public abstract Direction direction

(Optional) The direction of the stored procedure parameter.

Default:

org.eclipse.persistence.annotations.Direction.IN

queryParameter

public abstract java.lang.String queryParameter

(Optional) The query parameter name.

Default:

""

optional

public abstract boolean optional

(Optional) Define if the parameter is required, or optional and defaulted by the procedure.

Default:

false

databaseType

public abstract java.lang.String databaseType

(Optional) The database data-type for the paramter. This either one of the type constants defined in OraclePLSQLTypes, or JDBCTypes, or a custom record or table type name.

See Also:

PLSQLRecord, OraclePLSQLTypes, JDBCTypes

Default:

"VARCHAR_TYPE"

length

public abstract int length

(Optional) The max length of the field value.

Default:

255

scale

public abstract int scale

(Optional) If a numeric, the max scale value.

Default:

0

precision

public abstract int precision

(Optional) If a numeric, the max precision value.

Default:

0