Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 339721 - DBWS should support strongly-typed package REF CURSOR
Summary: DBWS should support strongly-typed package REF CURSOR
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: All All
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on: 339893
Blocks:
  Show dependency tree
 
Reported: 2011-03-11 11:52 EST by Mike Norman CLA
Modified: 2022-06-09 10:27 EDT (History)
2 users (show)

See Also:

Attachments
Builder code mods to customize the simple-xml tags with info from the cursor and record (22.23 KB, patch)
2012-05-07 16:14 EDT, David McCann CLA 		no flags Details | Diff
EnclosedTypeVisitor mod so PLSQLCursorType is only processed once (2.72 KB, patch)
2012-05-07 16:15 EDT, David McCann CLA 		no flags Details | Diff
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Norman CLA 2011-03-11 11:52:55 EST 
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;
Comment 1 David McCann CLA 2012-05-07 16:14:37 EDT 
Created attachment 215210 [details]
Builder code mods to customize the simple-xml tags with info from the cursor and record
Comment 2 David McCann CLA 2012-05-07 16:15:18 EDT 
Created attachment 215211 [details]
EnclosedTypeVisitor mod so PLSQLCursorType is only processed once
Comment 3 David McCann CLA 2012-05-07 16:17:18 EDT 
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...
Comment 4 David McCann CLA 2012-05-07 16:20:05 EDT 
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
Comment 5 David McCann CLA 2012-05-09 13:39:01 EDT 
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
Comment 6 Eclipse Webmaster CLA 2022-06-09 10:27:35 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink