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