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

Bug 325124

Summary: DBWS should support weakly-typed package REF CURSOR
Product: z_Archived Reporter: Mike Norman <michael.norman>
Component: EclipselinkAssignee: Mike Norman <michael.norman>
Status: RESOLVED FIXED QA Contact:
Severity: normal    
Priority: P3 CC: david.twelves, eclipselink.dbws-inbox
Version: unspecified   
Target Milestone: ---   
Hardware: All   
OS: All   
Whiteboard:

Description Mike Norman CLA 2010-09-13 11:17:05 EDT 
Package types AS
    Type cursor-type IS REF CURSOR
    Procedure GetEmpRS (p_deptno IN emp.deptno%TYPE, p_recordset OUT  
types.cursor_type);
END types

PACKAGE BODY Types is
PROCEDURE GetEmpRS (p_deptno IN emp.deptno%TYPE, p_recordset OUT
types.cursor_type) IS
BEGIN
  OPEN p_recordset FOR
    SELECT ename,
           empno,
           deptno
    FROM   emp
    WHERE  deptno = p_deptno
    ORDER BY ename;
END GetEmpRS; 

The request fails with ora-6550 and pl/sql 306 returned
Comment 1 Mike Norman CLA 2012-02-27 15:28:15 EST 
as of 12/02/27, the use-case below works so long as all of the other
types references in the package can be resolved - i.e. do not involve
any anchor types (%TYPE, %ROWTYPE) that cannot currently be resolved.
Comment 2 Eclipse Webmaster CLA 2022-06-09 10:09:23 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink