CREATE OR REPLACE PROCEDURE get_member_info ( p_member_id IN member.member_id%TYPE ) AS v_first_name member.first_name%TYPE; v_last_name member.last_name%TYPE; v_state member.state%TYPE; BEGIN SELECT first_name, last_name, state INTO v_first_name, v_last_name, v_state FROM member WHERE member_id = p_member_id; DBMS_OUTPUT.PUT_LINE(v_first_name || ' ' || v_last_name || ', ' || v_state); END; Error at line 13: PL/SQL: Statement ignored

在您提供的代码中，缺少一个分号。请在最后一个DBMS_OUTPUT.PUT_LINE之后添加分号，如下所示：

CREATE OR REPLACE PROCEDURE get_member_info (
    p_member_id IN member.member_id%TYPE
) AS
    v_first_name member.first_name%TYPE;
    v_last_name  member.last_name%TYPE;
    v_state      member.state%TYPE;
BEGIN
    SELECT first_name, last_name, state
    INTO v_first_name, v_last_name, v_state
    FROM member
    WHERE member_id = p_member_id;

    DBMS_OUTPUT.PUT_LINE(v_first_name || ' ' || v_last_name || ', ' || v_state);
END;