Skip to main content
Jump to: navigation, search

EclipseLink/DesignDocs/275156

< EclipseLink‎ | DesignDocs
Revision as of 11:02, 31 March 2011 by James.sutherland.oracle.com (Talk | contribs) (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] ...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Design Specification: PLSQL Procedures and Functions

ER 275156

Feedback

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.

Back to the top