openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "B.J. Reed (JIRA)" <>
Subject [jira] Updated: (OPENJPA-918) Stored procedures not handling returns properly
Date Tue, 24 Feb 2009 19:59:01 GMT


B.J. Reed updated OPENJPA-918:

    Attachment: TORC.patch

I've narrowed the problem down a little further.  Not sure if this is something that OpenJPA
is supposed to (or planning on) support or not...

I have attached as TORC.patch

The Oracle function is a function that returns a SYS_REFCURSOR

create or replace function selectAllApplicants  
cuApplicants SYS_REFCURSOR;  
open cuApplicants for  
select id, name from applicant;  
return cuApplicants;  
end selectAllApplicants;  

When I get the ResultList from the NativeQuery, I get an exception:
Missing IN or OUT parameter at index:: 1 {callstmnt 32580443 { ? = call selectAllApplicants()
}} [code=17041, state=null]

When I try the NativeQuery without the ? = , I get an exception that the procedure doesn't

> Stored procedures not handling returns properly
> -----------------------------------------------
>                 Key: OPENJPA-918
>                 URL:
>             Project: OpenJPA
>          Issue Type: New Feature
>          Components: query
>    Affects Versions: 2.0.0
>            Reporter: B.J. Reed
>            Assignee: B.J. Reed
>             Fix For: 2.0.0
>         Attachments: OPENJPA-918-test.patch, TORC.patch
> Stored procedures with output parameters are not being handled properly.  Patch will
be attached shortly with test cases.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message