Python Forum
Execute SQL Server Stored Procedures
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Execute SQL Server Stored Procedures
#5
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
Reply


Messages In This Thread
RE: Execute SQL Server Stored Procedures - by vikramprabhu - Oct-21-2020, 02:08 PM

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020