%%%%%%%%%%%%This is the given pl/sql Oracle code:%%%%%%%%%%%
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,
);
END;
/
%%%%%%%%%%This is my code:%%%%%%%%%%%%%
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)
%%%%%%%%%%%%%%%it has given me this error:%%%%%%%%%%%%%
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 35, in data |
%%%Thanks in Advance%%%%%