Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- declare
- v_order_id oe.orders.order_id%type := 1;
- v_order_item pkg_order_management.to_order_list := pkg_order_management.to_order_list();
- begin
- v_order_item.extend(2);
- v_order_item(1).product_id := 2289;
- v_order_item(1).quantity := 2;
- v_order_item(2).product_id := 2058;
- v_order_item(2).quantity := 5;
- pkg_order_management.prc_create_order(240, v_order_item, v_order_id);
- dbms_output.put_line('it was created the order: ' || v_order_id);
- end;
- declare
- v_order_id oe.orders.order_id%type := 1;
- begin
- pkg_order_management.prc_create_order(240, ((2289, 2),(2058, 5)), v_order_id);
- dbms_output.put_line('it was created the order: ' || v_order_id);
- end;
- type t_order_item is record
- ( product_id oe.order_items.product_id%type
- , quantity oe.order_items.quantity%type);
- type to_order_list is table of t_order_item;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement