Bugzilla – Full Text Bug Listing
| Summary: | DBWS should support strongly-typed package REF CURSOR | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | z_Archived | Reporter: | Mike Norman <michael.norman> | ||||||
| Component: | Eclipselink | Assignee: | Nobody - feel free to take it <nobody> | ||||||
| Status: | RESOLVED FIXED | QA Contact: | |||||||
| Severity: | normal | ||||||||
| Priority: | P3 | CC: | david.mccann, eclipselink.dbws-inbox | ||||||
| Version: | unspecified | ||||||||
| Target Milestone: | --- | ||||||||
| Hardware: | All | ||||||||
| OS: | All | ||||||||
| Whiteboard: | |||||||||
| Bug Depends on: | 339893 | ||||||||
| Bug Blocks: | |||||||||
| Attachments: |
|
||||||||
Created attachment 215210 [details]
Builder code mods to customize the simple-xml tags with info from the cursor and record
Created attachment 215211 [details]
EnclosedTypeVisitor mod so PLSQLCursorType is only processed once
This check-in adds support for strongly-typed ref cursors where the related stored procedure has only simple JDBC IN args, meaning that having PL/SQL IN args is not supported with cursors at this time... Partial fix for Bug 339721 - DBWS should support strongly-typed package REF CURSOR This fix provides support for ref cursors where the related stored procedure has only simeple JDBC IN args. Reviewed by: matt.macivor@oracle.com Tests: StrongRefCursorTestSuite; all unit tests pass as expected Revision: 11299 This bug will be closed, as basic cursor support has been implemented. The following bug has been opened to track lack of support for using cursors with advanced JDBC and/or PL/SQL input arguments: https://bugs.eclipse.org/bugs/show_bug.cgi?id=379029 The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink |
CREATE OR REPLACE PACKAGE PKG_STRONG_REFCURSOR IS TYPE PRICE_RECORD IS RECORD ( INDEX_RATE NUMBER(6,5), INDEX_TYPE VARCHAR2(1) ); TYPE STRONG_REFCURSOR IS REF CURSOR RETURN PRICE_RECORD; PROCEDURE FOO(P_RETURN OUT STRONG_REFCURSOR); END PKG_STRONG_REFCURSOR;