Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
EclipseLink/DesignDocs/275156
< EclipseLink | DesignDocs
Revision as of 12:02, 31 March 2011 by Unnamed Poltroon (Talk) (New page: <div style="margin:5px;float:right;border:1px solid #000000;padding:5px">__TOC__</div> = Design Specification: PLSQL Procedures and Functions = [http://bugs.eclipse.org/275156 ER 275156] ...)
Design Specification: PLSQL Procedures and Functions
Document History
| Date | Author | Version Description & Notes |
|---|---|---|
| 2011-03-31 | James | 0.1 Draft |
Project overview
The goal of this project is to extend our stored procedure support, including the following:
- PLSQL stored functions
- multiple result sets
- multiple cursor output parameters
- output cursors of record types
- optional arguments
- JPA annotation and XML support for stored functions
- JPA annotation and XML support for PLSQL procedures and functions
Concepts
PL/SQL is Oracle's SQL base language for defining stored procedures and functions.
Requirements
- PLSQL stored functions
- multiple result sets
- multiple cursor output parameters
- output cursors of record types
- optional arguments
- JPA annotation and XML support for stored functions
- JPA annotation and XML support for PLSQL procedures and functions
Design Constraints
Must be usable by a variety of different usages, DBWS, BPEL, JPA.
Functionality
Testing
Extend existing foundation and JPA stored procedure tests for new types of procedure being supported.
API
- StoredProcedureCall.
- PLSQLStoredFunctionCall
- @NamedStoredFunctionQuery
Config files
- orm.xml
<name-stored-procedure-query> </name-stored-procedure-query>
Documentation
Should be documented under query stored procedure section.
Open Issues
| Issue # | Owner | Description / Notes |
|---|---|---|
| 1 | What package to add JPA annotations to? | |
| 2 |
Decisions
| Issue | Description / Notes | Decision |
|---|
Future Considerations
- Other procedure functionality.