根据上面在错误代码解决这个代码CREATE OR REPLACE PACKAGE video IS PROCEDURE new_member (p_lname in member.last_name%TYPE, p_fname in member.first_name%TYPE Default null, p_address in member.address%TYPE default null, p_city in member.city%TYPE default null, p_phone in member.phone%type default null); function new_rental (p_member_id in rental.member_id%TYPE, p_title_id in rental.title_id%TYPE) return DATE; function new_rental (p_member_id in rental.member_id%TYPE, p_title_id in rental.title_id%TYPE) return DATE; function return_movie (p_title_id in rental.title_id%TYPE, p_copy_id in rental.copy_id%TYPE, p_status in title_copy.status%TYPE ); END video;
时间: 2024-03-05 21:48:42 浏览: 64
在这个代码中,有一个小错误。在 return_movie 函数的参数列表最后,多了一个不必要的分号。需要将它删除,修改后的代码如下:
```
CREATE OR REPLACE PACKAGE video IS
PROCEDURE new_member
(p_lname in member.last_name%TYPE,
p_fname in member.first_name%TYPE Default null,
p_address in member.address%TYPE default null,
p_city in member.city%TYPE default null,
p_phone in member.phone%type default null);
FUNCTION new_rental
(p_member_id in rental.member_id%TYPE,
p_title_id in rental.title_id%TYPE)
RETURN DATE;
FUNCTION new_rental
(p_member_id in rental.member_id%TYPE,
p_title_id in rental.title_id%TYPE)
RETURN DATE;
FUNCTION return_movie
(p_title_id in rental.title_id%TYPE,
p_copy_id in rental.copy_id%TYPE,
p_status in title_copy.status%TYPE
);
END video;
```
阅读全文