Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 366204

Summary:

DBWS: Need support for mixing PL/SQL and advanced JDBC args in a stored proc/func within a package

Product:

z_Archived

Reporter:

David McCann <david.mccann>

Component:

Eclipselink

Assignee:

David McCann <david.mccann>

Status:

RESOLVED FIXED

QA Contact:

Severity:

normal

Priority:

CC:

michael.norman

Version:

unspecified

Target Milestone:

---

Hardware:

All

OS:

All

Whiteboard:

Attachments:

Description	Flags
Proposed fix for mixing VArray and indexed tables	none
Supporting tests for mixing VArray and indexed tables	none
Proposed fix for mixing ObjectTypes and indexed tables	none
Supporting tests for mixing ObjectType and indexed tables	none
Proposed fix for mixing ObjectTables and PL/SQL types.	none
Supporting tests for mixing ObjectTable types and PL/SQL types	none
Proposed fix for ObjectTypes with VArray attribute.	none
Supporting tests for ObjectTypes containing VArray attributes.	none

Description David McCann

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

2011-12-09 14:30:40 EST

Created attachment 208195 [details]
Proposed fix for mixing VArray and indexed tables

Comment 2 David McCann

2011-12-12 16:15:02 EST

Created attachment 208288 [details]
Supporting tests for mixing VArray and indexed tables

Comment 3 David McCann

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

2011-12-15 12:19:58 EST

Created attachment 208455 [details]
Proposed fix for mixing ObjectTypes and indexed tables

Comment 5 David McCann

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

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

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

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

2011-12-19 11:17:04 EST

Created attachment 208563 [details]
Proposed fix for mixing ObjectTables and PL/SQL types.

Comment 10 David McCann

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

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

2011-12-21 13:02:48 EST

Created attachment 208699 [details]
Supporting tests for ObjectTypes containing VArray attributes.

Comment 13 David McCann

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

2022-06-09 10:03:50 EDT

The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink