Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. message_id_ number;
  2. order_no_ varchar2(20);
  3. supplier_no_ varchar2(20);
  4. c08_ varchar2(200);
  5.  
  6. cursor c1 is
  7. select c08
  8. from jdifs.out_message_line_tab
  9. where message_id = message_id_
  10. and name = 'HEADER';
  11.  
  12. message_id_ := message_id;
  13.  
  14. open c1;
  15. loop
  16. fetch c1
  17. into c08_;
  18. exit when c08_ is not null;
  19.  
  20. insert into jdifs.jdws_temp_line_tab
  21. values
  22. (message_id_, '2', c08_, '4');
  23. commit;
  24.  
  25. END LOOP;
  26.  
  27. close c1;
  28.  
  29. WHEN OTHERS THEN
  30. null;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement