Java Persistence API (JPA) Extensions Reference for EclipseLink, Release 2.5
  Go To Table Of Contents
 Search
 PDFComments
Comments


@PLSQLParameter

Use @PLSQLParameter within a NamedPLSQLStoredProcedureQuery or PLSQLRecord annotation.


Annotation Elements

Table 2-51 describes this annotation's elements.

Table 2-51 @PLSQLParameter Annotation Elements

Annotation Element Description Default

name

(Required) The query parameter name


direction

(Optional) The direction of the stored procedure parameter:

  • IN – Input parameter

  • IN_OUT – Input and output parameters

  • OUT – Output parameter

  • OUT_CURSOR – Output cursor

IN

databaseType

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


length

(Optional) Maximum length of the field value.


name

(Optional) Stored procedure parameter name


optional

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

false

scale

(Optional) Maximum precision value.


precision

(Optional) Maximum precision value.




Usage

Use the @PLSQLParameter annotation to configure the parameter and type for Oracle PLSQL stored procedures and record types that use extended PLSQL types instead of regular SQL types. They support PLSQL RECORD, TABLE, BOOLEAN and other extend PLSQL types.


Examples

See "@NamedPLSQLStoredProcedureQuery" for an example using the @PLSQLParameter annotation.


See Also

For more information: