Call Stored Procedure from Python Script

from __future__ import with_statement
from com.ziclix.python.sql import zxJDBC
from itertools import chain
import sys,os,csv
import re
#import urllib2
import wget

d, u, p, v = "jdbc:oracle:thin:@//host:1521/dbName", "apps", "password", "oracle.jdbc.driver.OracleDriver"
db = zxJDBC.connect(d, u, p, v)
c = db.cursor()
c.execute("BEGIN AppName.ProcName();END;")
c.close()
db.commit()
db.close()

file name would be: file.py

/**

select row and

insert row to table

#--select row from db table;fetch only one row

c.execute("select user_id from fnd_user where user_name='VIJAY'")

   swissUser = c.fetchone()

print swissUser

#--convert int to string --

swissUser = str(int(swissUser[0]))

   print "SWISS USER-->"+str(swissUser[0])

#--insert Row to database table

statement = "insert into APP.TBL_BALANCE_CON(FILE_LINE_NUMBER, ACCOUNTING_DATE, CURRENCY_CODE,) Values  ('1', TO_DATE('15-"+row[0]+"', 'DD-MON-YY'), 'STAT')"

print statement

c.execute(statement)

#fetch all rows in database table

c.execute("select line_number,to_char(accounting_date, 'mm/dd/yyyy') from  APP.TBL_BALANCES_CONVERSION")

       rowsLeftout = c.fetchall()

       lineFailed=lineFailed+" <tr>    <th>Line Number</th><th>Accounting Date</th><th>Period Name</th><th>Segment1</th><th>Segment3</th><th>Entered_Dr</th><th>Entered_Cr</th></tr>"

       for rowL in rowsLeftout:

          

          lineFailed=lineFailed+ "<tr>    <td>"+str(rowL[0])+"</td><td>"+str(rowL[1])+"</td><td>"+str(rowL[2])+"</td><td>"

       lineFailed=lineFailed+"</table> "

       print lineFailed

**/