如何在执行oracle存储过程时访问查询参数中的数据集参数

CREATE OR REPLACE PROCEDURE your_procedure_name (p_cursor OUT SYS_REFCURSOR, p_parameter1 IN VARCHAR2)
AS
BEGIN
  OPEN p_cursor FOR
    SELECT * FROM your_table WHERE column = p_parameter1;
END;

import java.sql.*;

public class YourClass {
    public static void main(String[] args) {
        String url = "jdbc:oracle:thin:@your_oracle_host:your_oracle_port:your_oracle_sid";
        String username = "your_username";
        String password = "your_password";
        
        try {
            Connection conn = DriverManager.getConnection(url, username, password);
            CallableStatement stmt = conn.prepareCall("{call your_procedure_name(?, ?)}");
            
            // 设置输入参数
            stmt.setString(2, "your_parameter_value");
            
            // 注册输出参数
            stmt.registerOutParameter(1, OracleTypes.CURSOR);
            
            // 执行存储过程
            stmt.execute();
            
            // 获取输出参数的游标
            ResultSet rs = (ResultSet) stmt.getObject(1);
            
            // 处理结果集
            while (rs.next()) {
                // 读取数据集参数中的数据
                String columnValue = rs.getString("column_name");
                // 进行相应的处理
            }
            
            // 关闭连接和资源
            rs.close();
            stmt.close();
            conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}