这是pl/sql代码:
CREATE OR REPLACE PACKAGE SALES_PHARMA_19.PKG_DIL_ABCD
IS
TYPE DIL10001_REC IS RECORD
(
DILCOLM_01 NUMBER,
DILCOLM_02 NUMBER,
DILCOLM_03 NUMBER,
DILCOLM_04 NUMBER
);
TYPE RC_DIL_10001 IS REF CURSOR
RETURN DIL10001_REC;
TYPE DIL10001_TAB IS TABLE OF DIL10001_REC
INDEX BY BINARY_INTEGER;
PROCEDURE PRC_DIL10001 (P_REF_DIL001 IN OUT RC_DIL_10001,
P_PERREQ_BY IN NUMBER,
P_UD_REQ_BY IN VARCHAR2,
P_DESIGCODE IN VARCHAR2--,
-- P_SFRMST_DT IN DATE,
-- P_SENDTO_DT IN DATE
);
END;
/
这是程序包的主体:
PROCEDURE PRC_DIL10001 (P_REF_DIL001 IN OUT RC_DIL_10001,
P_PERREQ_BY IN NUMBER,
P_UD_REQ_BY IN VARCHAR2,
P_DESIGCODE IN VARCHAR2--,
-- P_SFRMST_DT IN DATE,
-- P_SENDTO_DT IN DATE
)
IS
BEGIN
OPEN P_REF_DIL001 FOR
SELECT 4 DILCOLM_01,
2 DILCOLM_02,
1 DILCOLM_03,
1 DILCOLM_04
FROM DUAL;
END;
这是我的Python代码:
def data(request):
userpwd = "__"
connection = cx_Oracle.connect("user", userpwd, "192.168.0.1:1501/orcl")
curs = connection.cursor()
record = curs.arrayvar(cx_Oracle.NUMBER, [1, 2, 3, 4])
t = [0, '1', '2']
k = curs.callproc("PKG_DIL_ABCD.PRC_DIL10001", [record, t])
for i in record.getvalue():
print(i)
这是给定的错误:
NotSupportedError at /data/ element 1 value is not the same type as previous elements Request Method: GET Request URL: http://127.0.0.1:8000/data/ Django Version: 3.1.3 Exception Type: NotSupportedError Exception Value: element 1 value is not the same type as previous elements Exception Location: D:\s h o w n o k\Practice_Project\oracle_api\o_api\myapp\views.py, line 31, in data Python Executable: C:\Users\ATI\AppData\Local\Programs\Python\Python37-32\python.exe Python Version: 3.7.2
在您的代码中有以下内容:
请注意,第一个元素是整数,其余元素是字符串。它们必须是同一类型的
此外,必须按this sample所示处理记录
相关问题 更多 >
编程相关推荐