Oct-21-2020, 02:08 PM
I am trying to read OUT Parameter from an Oracle Stored Procedure which is an array.
Oracle Stored Proc:
create or replace PROCEDURE PRC_LV_FASTREPORT_RPT (v_start_date IN DATE, v_end_date IN DATE,l_nt OUT LV_FASTREPORT_RPT_tab)
Python Call:
---
cur = conn.cursor()
args = (date_from.__format__('%d-%b-%Y'),date_to.__format__('%d-%b-%Y'), 0)
result_args = cur.callproc('PRC_LV_FASTREPORT_RPT', args)
----
Error I get:
wrong number or types of arguments in call to 'PRC_LV_FASTREPORT_RPT'
---
Can you please let me know if I am doing anything wrong?
Is it the right way to read an Array Output from Stored Proc?
Thank you,
- VP
Oracle Stored Proc:
create or replace PROCEDURE PRC_LV_FASTREPORT_RPT (v_start_date IN DATE, v_end_date IN DATE,l_nt OUT LV_FASTREPORT_RPT_tab)
Python Call:
---
cur = conn.cursor()
args = (date_from.__format__('%d-%b-%Y'),date_to.__format__('%d-%b-%Y'), 0)
result_args = cur.callproc('PRC_LV_FASTREPORT_RPT', args)
----
Error I get:
wrong number or types of arguments in call to 'PRC_LV_FASTREPORT_RPT'
---
Can you please let me know if I am doing anything wrong?
Is it the right way to read an Array Output from Stored Proc?
Thank you,
- VP