1 Reply Latest reply: Dec 16, 2009 5:12 PM by 390020 RSS

    How to execute a procedure with cx_oracle

    741594
      Hi,

      I would like to know if it's possible to execute a stored procedure already compiled and stored in the database. I am trying to execute it by doing the following in python?

      cur.exectute("exec stored_procedure;")

      If this is not correct, then is there a statement I can pass to cur.execute() to execute a stored procedure. Please note that I am not asking about coding a procedure in cx_oracle and then excuting it using Python. I am just looking to execute a procedure already present in the database using cx_oracle.

      Thanks,
      Abdul