Use @PLSQLParameter
within a NamedPLSQLStoredProcedureQuery
or PLSQLRecord
annotation.
Table 2-50 describes this annotation's elements.
Table 2-50 @PLSQLParameter Annotation Elements
Annotation Element | Description | Default |
---|---|---|
|
(Required) The query parameter name |
|
|
(Optional) The direction of the stored procedure parameter:
|
|
|
(Optional) Database data type for the parameter. This either one of the type constants defined in |
|
|
(Optional) Maximum length of the field value. |
|
|
(Optional) Stored procedure parameter name |
|
|
(Optional) Specify if the parameter is required, or optional and defaulted by the procedure. |
|
|
(Optional) Maximum precision value. |
|
|
(Optional) Maximum precision value. |
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.
See "@NamedPLSQLStoredProcedureQuery" for an example using the @PLSQLParameter
annotation.
For more information: