This Bugzilla instance is deprecated, and most Eclipse projects now use GitHub or Eclipse GitLab. Please see the deprecation plan for details.
Bug 303333 - Handle overloaded Stored Procedure/Functions as WSDL operations
Summary: Handle overloaded Stored Procedure/Functions as WSDL operations
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: 2010-02-19 11:07 EST by Mike Norman CLA
Modified: 2022-06-09 10:03 EDT (History)
2 users (show)

See Also:


Attachments
Proposed fix. (33.15 KB, patch)
2011-03-14 15:26 EDT, David McCann CLA
no flags Details | Diff
Supporting test(s). (8.24 KB, patch)
2011-03-14 15:27 EDT, David McCann CLA
no flags Details | Diff
Proposed fix v2 - reverted a number of formatting changes to make diff less complex (57.92 KB, patch)
2011-03-15 10:50 EDT, David McCann CLA
no flags Details | Diff
Proposed fix v3 (59.82 KB, patch)
2011-03-18 15:41 EDT, David McCann CLA
no flags Details | Diff
Supporting test v2 (59.82 KB, patch)
2011-03-18 15:41 EDT, David McCann CLA
no flags Details | Diff
Proposed fix v4 (11.08 KB, patch)
2011-03-25 13:39 EDT, David McCann CLA
no flags Details | Diff
Supporting tests (20.97 KB, patch)
2011-03-25 13:39 EDT, David McCann CLA
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Norman CLA 2010-02-19 11:07:13 EST
When someFunc is overloaded (i.e. appears multiple time in a package with
different arguments):
    PACKAGE pkg_with_overloaded_methods IS
        FUNCTION someFunc(A VARCHAR2) RETURN VARCHAR2;
        FUNCTION someFunc(A VARCHAR2,
          B VARCHAR2 := 'BBB')
        RETURN VARCHAR2;
        FUNCTION someFunc(A VARCHAR2,
          B VARCHAR2 := 'BBB',
          C VARCHAR2 := 'CCC')
        RETURN VARCHAR2;
    ...
There is a problem representing this in WSDL - it does not support overloading.
It may be possible to do some sort of 'name mangling' (add overlay number to
operation); however, this is likely to require changes to the work planned for
bug 290156
Comment 1 David McCann CLA 2011-03-14 15:26:44 EDT
Created attachment 191159 [details]
Proposed fix.
Comment 2 David McCann CLA 2011-03-14 15:27:08 EDT
Created attachment 191160 [details]
Supporting test(s).
Comment 3 David McCann CLA 2011-03-15 10:50:10 EDT
Created attachment 191216 [details]
Proposed fix v2 - reverted a number of formatting changes to make diff less complex
Comment 4 David McCann CLA 2011-03-18 15:41:28 EDT
Created attachment 191548 [details]
Proposed fix v3
Comment 5 David McCann CLA 2011-03-18 15:41:46 EDT
Created attachment 191549 [details]
Supporting test v2
Comment 6 David McCann CLA 2011-03-25 13:39:23 EDT
Created attachment 191927 [details]
Proposed fix v4
Comment 7 David McCann CLA 2011-03-25 13:39:40 EDT
Created attachment 191928 [details]
Supporting tests
Comment 8 David McCann CLA 2011-03-29 11:04:57 EDT
Reviewed by:  michael.norman@oracle.com
Tests:  all unit tests pass as expected; dbws\testing\visit\OverloadedPLSQLStoredProcedureTestSuite; dbws\testing\visit\OverloadedPLSQLStoredProcedureSimpleArgsTestSuite
Revision: 9185
Comment 9 David McCann CLA 2011-03-29 14:48:17 EDT
Note that for two PL/SQL procs,

GetEmp(FOO IN VARCHAR2)
GetEmp(FOO IN VARCHAR2, BAR IN VARCHAR2)

the corresponding .wsdl entries will be in the format 'GetEmp1xxx' and 'GetEmp2xxx'
Comment 10 Eclipse Webmaster CLA 2022-06-09 10:03:16 EDT
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink