Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 325124 - DBWS should support weakly-typed package REF CURSOR
Summary: DBWS should support weakly-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: Mike Norman CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-09-13 11:17 EDT by Mike Norman CLA
Modified: 2022-06-09 10:09 EDT (History)
2 users (show)

See Also:

Attachments
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 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