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 |
---|---|---|
|
(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. |
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:
PLSQL Stored Procedure Examples
http://wiki.eclipse.org/EclipseLink/Examples/JPA/PLSQLStoredFunction