在Oracle PLSQL过程的输出中需要帮助

-- 开启DBMS_OUTPUT输出
SET SERVEROUTPUT ON;

-- 输出文本
DBMS_OUTPUT.PUT_LINE('输出信息');

-- 示例过程，包含一个OUT参数
CREATE OR REPLACE PROCEDURE output_message(p_message OUT VARCHAR2) AS
BEGIN
  p_message := '输出信息';
END;

DECLARE
  v_message VARCHAR2(100);
BEGIN
  output_message(v_message);
  DBMS_OUTPUT.PUT_LINE(v_message);
END;

-- 示例过程，包含一个游标参数
CREATE OR REPLACE PROCEDURE output_results(p_cursor OUT SYS_REFCURSOR) AS
BEGIN
  OPEN p_cursor FOR SELECT column_name FROM table_name;
END;

DECLARE
  v_cursor SYS_REFCURSOR;
  v_column_name table_name.column_name%TYPE;
BEGIN
  output_results(v_cursor);
  
  LOOP
    FETCH v_cursor INTO v_column_name;
    EXIT WHEN v_cursor%NOTFOUND;
    DBMS_OUTPUT.PUT_LINE(v_column_name);
  END LOOP;
  
  CLOSE v_cursor;
END;