Use @NamedPLSQLStoredProcedureQueries annotation to define multiple NamedPLSQLStoredProcedureQuery items.
Table 2-36 describes this annotation's elements.
Table 2-36 @NamedPLSQLStoredProcedureQueries Annotation Elements
| Annotation Element | Description | Default |
|---|---|---|
|
|
(Required) An array of named stored procedure query. |
Example 2-68 shows how to use this annotation.
Example 2-68 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") } )
})
For more information, see:
"Stored Procedures" in Understanding Oracle TopLink
Oracle PL/SQL
http://www.oracle.com/technetwork/database/features/plsql/index.html