Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- message_id_ number;
- order_no_ varchar2(20);
- supplier_no_ varchar2(20);
- c08_ varchar2(200);
- cursor c1 is
- select c08
- from jdifs.out_message_line_tab
- where message_id = message_id_
- and name = 'HEADER';
- message_id_ := message_id;
- open c1;
- loop
- fetch c1
- into c08_;
- exit when c08_ is not null;
- insert into jdifs.jdws_temp_line_tab
- values
- (message_id_, '2', c08_, '4');
- commit;
- END LOOP;
- close c1;
- WHEN OTHERS THEN
- null;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement