Advertisement
Guest User

Untitled

a guest
Aug 20th, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. declare
  2. v_order_id oe.orders.order_id%type := 1;
  3.  
  4. v_order_item pkg_order_management.to_order_list := pkg_order_management.to_order_list();
  5. begin
  6.  
  7. v_order_item.extend(2);
  8. v_order_item(1).product_id := 2289;
  9. v_order_item(1).quantity := 2;
  10.  
  11. v_order_item(2).product_id := 2058;
  12. v_order_item(2).quantity := 5;
  13. pkg_order_management.prc_create_order(240, v_order_item, v_order_id);
  14. dbms_output.put_line('it was created the order: ' || v_order_id);
  15. end;
  16.  
  17. declare
  18. v_order_id oe.orders.order_id%type := 1;
  19. begin
  20. pkg_order_management.prc_create_order(240, ((2289, 2),(2058, 5)), v_order_id);
  21. dbms_output.put_line('it was created the order: ' || v_order_id);
  22. end;
  23.  
  24. type t_order_item is record
  25. ( product_id oe.order_items.product_id%type
  26. , quantity oe.order_items.quantity%type);
  27.  
  28. type to_order_list is table of t_order_item;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement