Advertisement
Guest User

Untitled

a guest
Nov 27th, 2014
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. int count = 0;
  2. String id = "m123"
  3.  
  4. count = getEm().createNativeQuery("call sample_procedure(?,?)").setParameter(1, id).setParameter(2, count)
  5. .executeUpdate();
  6.  
  7. create or replace
  8. PROCEDURE sample_procedure(
  9. id IN VARCHAR,
  10. count OUT NUMBER)
  11. IS
  12. ........
  13. BEGIN
  14. .....
  15. LOOP
  16. ---------
  17. count := count + 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement