Oracle为超市会员管理系统写三个存储过程，需要写调用语句

好的，我可以为您提供三个Oracle存储过程及其调用语句，您可以参考如下：

1. 存储过程名称：sp_insert_member

-- 存储过程代码
CREATE OR REPLACE PROCEDURE sp_insert_member (
p_member_id IN NUMBER,
p_member_name IN VARCHAR2,
p_member_phone IN VARCHAR2,
p_join_date IN DATE
)
IS
BEGIN
INSERT INTO member_table (
member_id,
member_name,
member_phone,
join_date
) VALUES (
p_member_id,
p_member_name,
p_member_phone,
p_join_date
);
COMMIT;
END;

-- 调用语句
EXEC sp_insert_member(1, '张三', '13812345678', '2021-01-01');

2. 存储过程名称：sp_update_member

-- 存储过程代码
CREATE OR REPLACE PROCEDURE sp_update_member (
p_member_id IN NUMBER,
p_member_name IN VARCHAR2,
p_member_phone IN VARCHAR2,
p_join_date IN DATE
)
IS
BEGIN
UPDATE member_table
SET member_name = p_member_name,
member_phone = p_member_phone,
join_date = p_join_date
WHERE member_id = p_member_id;
COMMIT;
END;

-- 调用语句
EXEC sp_update_member(1, '李四', '13987654321', '2021-02-01');

3. 存储过程名称：sp_delete_member

-- 存储过程代码
CREATE OR REPLACE PROCEDURE sp_delete_member (
p_member_id IN NUMBER
)
IS
BEGIN
DELETE FROM member_table
WHERE member_id = p_member_id;
COMMIT;
END;

-- 调用语句
EXEC sp_delete_member(1);