Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 366204 - DBWS: Need support for mixing PL/SQL and advanced JDBC args in a stored proc/func within a package
Summary: DBWS: Need support for mixing PL/SQL and advanced JDBC args in a stored proc/...
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: David McCann CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-12-09 10:17 EST by David McCann CLA
Modified: 2022-06-09 10:03 EDT (History)
1 user (show)

See Also:

Attachments
Proposed fix for mixing VArray and indexed tables (19.86 KB, patch)
2011-12-09 14:30 EST, David McCann CLA 		no flags Details | Diff
Supporting tests for mixing VArray and indexed tables (31.75 KB, patch)
2011-12-12 16:15 EST, David McCann CLA 		no flags Details | Diff
Proposed fix for mixing ObjectTypes and indexed tables (17.52 KB, patch)
2011-12-15 12:19 EST, David McCann CLA 		no flags Details | Diff
Supporting tests for mixing ObjectType and indexed tables (34.57 KB, patch)
2011-12-15 12:21 EST, David McCann CLA 		no flags Details | Diff
Proposed fix for mixing ObjectTables and PL/SQL types. (11.83 KB, patch)
2011-12-19 11:17 EST, David McCann CLA 		no flags Details | Diff
Supporting tests for mixing ObjectTable types and PL/SQL types (15.92 KB, patch)
2011-12-19 11:17 EST, David McCann CLA 		no flags Details | Diff
Proposed fix for ObjectTypes with VArray attribute. (13.27 KB, patch)
2011-12-21 13:02 EST, David McCann CLA 		no flags Details | Diff
Supporting tests for ObjectTypes containing VArray attributes. (13.27 KB, patch)
2011-12-21 13:02 EST, 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 David McCann CLA 2011-12-09 10:17:55 EST 
We currently don't support PL/SQL procedures/functions (in a package) that have both PL/SQL complex arguments and advanced JDBC arguments.  We need to modify how we process these - i.e. for producing ORM/OXM projects, schema, service, WSDL, etc. - as well as anonymous PL/SQL code generation.
Comment 1 David McCann CLA 2011-12-09 14:30:40 EST 
Created attachment 208195 [details]
Proposed fix for mixing VArray and indexed tables
Comment 2 David McCann CLA 2011-12-12 16:15:02 EST 
Created attachment 208288 [details]
Supporting tests for mixing VArray and indexed tables
Comment 3 David McCann CLA 2011-12-12 16:18:43 EST 
Checked in fix part#1, which adds support for mixing VArray and Indexed table types as arguments.  Revision: 10547

Reviewed by:  michael.norman@oracle.com 

Tests:  all DBWS, MOXY and SDO unit tests pass as expected; core SRG and LRG tests pass; ComplexPLSQLSFTestSuite & ComplexPLSQLSPTestSuite were added
Comment 4 David McCann CLA 2011-12-15 12:19:58 EST 
Created attachment 208455 [details]
Proposed fix for mixing ObjectTypes and indexed tables
Comment 5 David McCann CLA 2011-12-15 12:21:42 EST 
Created attachment 208456 [details]
Supporting tests for mixing ObjectType and indexed tables

Also contains more testing of mixed IN args, i.e. ObjectType + VArray, ObjectType + PL/SQL Collection, etc.
Comment 6 David McCann CLA 2011-12-15 13:56:37 EST 
Checked in fix part#1, which adds support for mixing ObjectType and Indexed table
types as arguments.  Revision: 10577

Reviewed by:  michael.norman@oracle.com 

Tests:  all DBWS, MOXY and SDO unit tests pass as expected; core SRG and LRG
tests pass; ComplexPLSQLSFTestSuite & ComplexPLSQLSPTestSuite were modified
Comment 7 David McCann CLA 2011-12-15 13:56:59 EST 
Checked in fix part#2, which adds support for mixing ObjectType and Indexed table
types as arguments.  Revision: 10577

Reviewed by:  michael.norman@oracle.com 

Tests:  all DBWS, MOXY and SDO unit tests pass as expected; core SRG and LRG
tests pass; ComplexPLSQLSFTestSuite & ComplexPLSQLSPTestSuite were modified
Comment 8 David McCann CLA 2011-12-15 13:58:00 EST 
IGNORE THIS - see 'fix part#2' below

(In reply to comment #6)
> Checked in fix part#1, which adds support for mixing ObjectType and Indexed
> table
> types as arguments.  Revision: 10577
> 
> Reviewed by:  michael.norman@oracle.com 
> 
> Tests:  all DBWS, MOXY and SDO unit tests pass as expected; core SRG and LRG
> tests pass; ComplexPLSQLSFTestSuite & ComplexPLSQLSPTestSuite were modified
Comment 9 David McCann CLA 2011-12-19 11:17:04 EST 
Created attachment 208563 [details]
Proposed fix for mixing ObjectTables and PL/SQL types.
Comment 10 David McCann CLA 2011-12-19 11:17:41 EST 
Created attachment 208564 [details]
Supporting tests for mixing ObjectTable types and PL/SQL types
Comment 11 David McCann CLA 2011-12-21 13:02:06 EST 
Created attachment 208698 [details]
Proposed fix for ObjectTypes with VArray attribute.

CustomerType has VArray, VarChar2 and ObjectType attributes.  The ObjectType attribute has a nested ObjectType as well (CustomerType -> ContactType -> PhoneType)
Comment 12 David McCann CLA 2011-12-21 13:02:48 EST 
Created attachment 208699 [details]
Supporting tests for ObjectTypes containing VArray attributes.
Comment 13 David McCann CLA 2012-01-09 11:16:03 EST 
Current support:
- indexed table + varray
- object type + indexed table
- pl/sql record + varay
- pl/sql record + indexed table
- object type table + pl/sql record
- object type table + indexed table

Closing as fixed.
Comment 14 Eclipse Webmaster CLA 2022-06-09 10:03:50 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink