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 11:48:40 浏览: 69
在这段代码中,有两个函数名称相同的函数:new_rental。这是不允许的,应该将其中一个函数重命名。另外,代码中有一些拼写错误,例如“胃”应该是“味”。最后,应该在代码的结尾处添加一个分号。修改后的代码如下:
```
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_rental1
(p_member_id in rental.member_id%TYPE,
p_title_id in rental.title_id%TYPE)
return DATE;
function new_rental2
(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;
```
阅读全文