@PLSQLParameter

Use @PLSQLParameter within a NamedPLSQLStoredProcedureQuery or PLSQLRecord annotation.

Annotation Elements

Table 2-50 describes this annotation's elements.

Table 2-50 @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.