Annotation Type NamedPLSQLStoredProcedureQuery
A PLSQLNamedStoredProcedureQuery annotation allows the definition of queries that
call PLSQL stored procedures as named queries.
The PLSQL support adds support for complex PLSQL types such as RECORD and TABLE types,
that are not accessible from JDBC.
A PLSQLNamedStoredProcedureQuery annotation may be defined on an Entity or
MappedSuperclass.
- Author:
- James Sutherland
-
Required Element Summary
Required ElementsModifier and TypeRequired ElementDescription(Required) Unique name that references this stored procedure query.(Required) The name of the stored procedure. -
Optional Element Summary
Optional ElementsModifier and TypeOptional ElementDescriptionjakarta.persistence.QueryHint[]
(Optional) Query hints.(Optional) Defines the parameters to the stored procedure.(Optional) Refers to the class of the result.(Optional) The name of the SQLResultMapping.
-
Element Details
-
-
hints
jakarta.persistence.QueryHint[] hints(Optional) Query hints.- Default:
- {}
-
resultClass
Class resultClass(Optional) Refers to the class of the result.- Default:
- void.class
-
resultSetMapping
String resultSetMapping(Optional) The name of the SQLResultMapping.- Default:
- ""
-
parameters
PLSQLParameter[] parameters(Optional) Defines the parameters to the stored procedure.- Default:
- {}
-