Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- TYPE t_nums IS TABLE OF NUMBER(38);
- v_actual_nums t_nums := t_nums(0, 12, 1, 3, 0);
- v_expected_nums t_nums := t_nums(12, 1, 3, 0, 0);
- FUNCTION move_zeroes(p_nums t_nums) RETURN t_nums IS
- BEGIN
- -- YOUR CODE HERE
- END;
- PROCEDURE test(p_expected_nums t_nums
- ,p_actual_nums t_nums) IS
- BEGIN
- IF (p_expected_nums IS NULL OR p_actual_nums IS NULL OR p_expected_nums.COUNT != p_actual_nums.COUNT) THEN
- raise_application_error(-20100, 'Arrays are not equals');
- END IF;
- FOR i IN p_expected_nums.FIRST .. p_expected_nums.LAST LOOP
- IF (p_expected_nums(i) != p_actual_nums(i)) THEN
- raise_application_error(-20100, 'Arrays are not equals');
- END IF;
- END LOOP;
- END;
- BEGIN
- v_actual_nums := move_zeroes(v_actual_nums);
- test(v_expected_nums, v_actual_nums);
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement