@NamedPLSQLStoredProcedureQueries

Use @NamedPLSQLStoredProcedureQueries annotation to define multiple NamedPLSQLStoredProcedureQuery items.

Annotation Elements

Table 2-37 describes this annotation's elements.

Table 2-37 @NamedPLSQLStoredProcedureQueries Annotation Elements

Annotation Element	Description	Default
`value`	(Required) An array of named stored procedure query.

Examples

Example 2-69 shows how to use this annotation.

Example 2-69 Using @NamedPLSQLStoredProcedureQueries Annotation

@NamedPLSQLStoredProcedureQueries({ 
    @NamedPLSQLStoredProcedureQuery(name="getEmployee", 
    functionName="EMP_PKG.GET_EMP", 
    parameters={ @PLSQLParameter( name="EMP_OUT", direction=:Direction.OUT, databaseType="EMP_PKG.EMP_REC") } )
    })

See Also

For more information, see:

"@NamedPLSQLStoredProcedureQuery"
"Stored Procedures" in Understanding EclipseLink
Oracle PL/SQL
http://www.oracle.com/technetwork/database/features/plsql/index.html
PLSQL Stored Procedure Examples
http://wiki.eclipse.org/EclipseLink/Examples/JPA/PLSQLStoredFunction