NamedStoredFunctionQuery (EclipseLink 2.7.15, API Reference)

```
@Target(TYPE)
@Retention(RUNTIME)
@Repeatable(NamedStoredFunctionQueries.class)
public @interface NamedStoredFunctionQuery
```
A NamedStoredFunctionQuery annotation allows the definition of queries that call stored functions as named queries. A NamedStoredFunctionQuery annotation may be defined on an Entity or MappedSuperclass.

Author:

James

Since:

EclipseLink 2.3

Required Element Summary

Required Elements
Modifier and Type	Required Element	Description
`java.lang.String`	`functionName`	(Required) The name of the stored function.
`java.lang.String`	`name`	(Required) Unique name that references this stored function query.
`StoredProcedureParameter`	`returnParameter`	(Required) Defines the return value of the stored function.

Optional Element Summary

Optional Elements
Modifier and Type	Optional Element	Description
`boolean`	`callByIndex`	(Optional) Defines if the stored procedure should be called by index or by name.
`QueryHint[]`	`hints`	(Optional) Query hints.
`StoredProcedureParameter[]`	`parameters`	(Optional) Defines the parameters to the stored function.
`java.lang.String`	`resultSetMapping`	(Optional) The name of the SQLResultMapping.

- Element Detail
  - name
```
java.lang.String name
```
    (Required) Unique name that references this stored function query.
- - functionName
```
java.lang.String functionName
```
    (Required) The name of the stored function.
- - returnParameter
```
StoredProcedureParameter returnParameter
```
    (Required) Defines the return value of the stored function.
- - hints
```
QueryHint[] hints
```
    (Optional) Query hints.
    
    Default:
    
    {}
- - resultSetMapping
```
java.lang.String resultSetMapping
```
    (Optional) The name of the SQLResultMapping.
    
    Default:
    
    ""
- - callByIndex
```
boolean callByIndex
```
    (Optional) Defines if the stored procedure should be called by index or by name. By index requires that the StoredProcedureParameter are defined in the same order as the procedure on the database. By name requires the database platform support naming procedure parameters.
    
    Default:
    
    false
- - parameters
```
StoredProcedureParameter[] parameters
```
    (Optional) Defines the parameters to the stored function.
    
    Default:
    
    {}