python - 从python中的oracle存储过程中读取二维数组输出参数

Question

我有一个如下的存储过程。

procedure download_data(
    id             in number,
    test_ids            in test_num_array := test_num_array(),
    data_instance    out sys_refcursor,
    titles            out test_two_dim_array
  ) ----
---------

我正在编写一个python程序，如下所示

connection = Util.getConnection()

cursor=connection.cursor()
cur_var=cursor.var(cx_Oracle.CURSOR)
id = cursor.var(cx_Oracle.NUMBER, 123456)
test_ids = cursor.arrayvar(cx_Oracle.NUMBER, [123456, 7890])
titles   = [[]]
cursor.callproc("fast_rprt_dwnld.download_analysis_data_fs2", [id, test_ids,cur_var,titles])

print(titles)

出现以下错误：

"errorMessage": "element 0 value is unsupported",

标签： pythonstored-procedurescx-oracle