Home/ Questions/Q 2636
In Process

vinish.ai Latest Questions

  • 1
  • 1
Asked: 2020-10-21T19:15:08+00:00

Array O/P Stored Proc in Python

  • 1
  • 1

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?

sp
Share
Leave an answer

Leave an answer

Browse

1 Answer

  1. To get the OUT parameter value, you should use the variable instead of the value (like you are using as 0). Below is an example to get the OUT parameter value:

    cur = conn.cursor()
outVal = cursor.var(int)
args = (date_from.__format__('%d-%b-%Y'),date_to.__format__('%d-%b-%Y'), outVal)
result_args = cur.callproc('PRC_LV_FASTREPORT_RPT', args)

    But in your case, you have the object type array. So try the below code:

    objType = conn.gettype("LV_FASTREPORT_RPT_tab")
cur = conn.cursor()
args = (date_from.__format__('%d-%b-%Y'),date_to.__format__('%d-%b-%Y'), objType)
result_args = cur.callproc('PRC_LV_FASTREPORT_RPT', args)