[
https://issues.apache.org/jira/browse/OPENJPA-918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
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 TestOracleRefCursor.java as TORC.patch
The Oracle function is a function that returns a SYS_REFCURSOR
create or replace function selectAllApplicants
return SYS_REFCURSOR
as
cuApplicants SYS_REFCURSOR;
begin
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 exist.
> Stored procedures not handling returns properly
> -----------------------------------------------
>
> Key: OPENJPA-918
> URL: https://issues.apache.org/jira/browse/OPENJPA-918
> 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.
