index:：1 Oracle中缺少IN或OUT参数

CREATE [OR REPLACE] PROCEDURE procedure_name (parameter_name [IN | OUT] data_type [, ...])
IS
BEGIN
    -- procedure body
END;

CREATE [OR REPLACE] FUNCTION function_name (parameter_name [IN | OUT] data_type [, ...])
RETURN return_data_type
IS
BEGIN
    -- function body
END;

CREATE OR REPLACE PROCEDURE get_employee_details (employee_id IN NUMBER)
IS
    -- procedure body
BEGIN
    -- retrieve employee details based on employee_id
END;

CREATE OR REPLACE PROCEDURE calculate_salary (employee_id IN NUMBER, salary OUT NUMBER)
IS
    -- procedure body
BEGIN
    -- calculate salary based on employee_id and assign it to salary parameter
END;

CREATE OR REPLACE FUNCTION get_employee_name (employee_id IN NUMBER)
RETURN VARCHAR2
IS
    -- function body
BEGIN
    -- retrieve employee name based on employee_id and return it
END;

CREATE OR REPLACE FUNCTION calculate_bonus (employee_id IN NUMBER, bonus OUT NUMBER)
RETURN NUMBER
IS
    -- function body
BEGIN
    -- calculate bonus based on employee_id and assign it to bonus parameter
    RETURN bonus;
END;