on 07-14-2011 1:38 PM
Hi
Can we call stored procedures using SAP implementation of JPA. I had no success till now. I tried to call using named query and native query.
Thanks
Vidyadhar
Hi
on SAP JPA with system data source, native queries are not "really" native but Open SQL queries.
see Adrian Görlers post how to solve this:
This hint and query.executeUpdate() should work.
Cheers
Rolf
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
named queries are made for selects that return objects.
You might try to change your stored procedure to a function returning e.g. 1 (number) and call it with "select myfunc from dual".
If you really need named query support for PL/SQL consider to switch to eclipselink. They have extended PL/SQL support in their latest release.
Regards
Rolf
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.