cx_oracle函数返回类型,Python“cx”_Oracle.InterfaceError：not a query“for Oracle函数返回类型curs”...

请帮助我理解我做错了什么，因为如果我执行的过程给出了多行响应，但在python中执行的过程失败了，并且在游标调用函数时出现异常，那么这个值是相同的。在-----Oracle Function----------

FUNCTION get_details (id IN VARCHAR2, actNo IN VARCHAR2, code IN VARCHAR2)

RETURN SYS_REFCURSOR

----Oracle Function Logic----------

OPEN cur_msg_dtls FOR SELECT NAME,VALUE,CODE FROM TABLE

returns cur_msg_dtls

----Python Code--------

import cx_Oracle

if __name__ == '__main__':

con = cx_Oracle.connect('username/pass@host.com:1521/schema')

cur_var = con.cursor()

actNo = 'actNo';

code ='Code';

Id ='Id';

try:

cur_var.callfunc('SCHEMA.PKG.GET_DETAILS',cx_Oracle.CURSOR, (Id,actNo, actCd))

print ("hello")

print(cur_var)

print(type(cur_var))

for row in cur_var:

print(row)

except cx_Oracle.DatabaseError as e:

print (e)

finally:

cur_var.close()

con.close()

pass

----Error--------------

hello

>

Traceback (most recent call last):

File "C:\Users\TestDBPRoc.py", line 26, in

for row in cur_var:

cx_Oracle.InterfaceError: not a query