title: Python3: cx_Oracle - Execute a local procedure
body: <p>I am working with cx_Oracle in Python3. I am stuck with local procedure part.We have a procedure but its not stored procedure. I have that code locally and not in Oracle server.</p>
  
  <p>How can I execute that procedure and I need to pass argument to that Procedure.</p>
  
  <p>Can I call it from a local file or do I have to place entire procedure code in a file and call it as a query ?</p>
  
  <p>As my server is a live one and I am not trying to do any experiments.</p>
  
  <p>EDIT: This is how my procedure looks like. I have removed few contents but this is the blue print of it</p>
  
  <pre><code>DECLARE
  PROCEDURE insertOrUpdateITEM (ip IN CHAR) IS
  BEGIN
    INSERT STATEMENT HERE
  EXCEPTION
    WHEN DUP_VAL_ON_INDEX THEN
      UPDATE   
      SET      
      WHERE    
  END insertOrUpdateITEM;
  
  BEGIN
  insertOrUpdateITEM('192.168.56.101');
  END;
  </code></pre>
  
  <p>Thank you.</p>