[Jython-users] Oracle Stored Proc

[Peter O'Reilly]

This Jython code is failing,
from com.ziclix.python.sql import zxJDBC
    try:    
        conn = zxJDBC.connect("jdbc:oracle:thin:@myserver.com:1999:company",'APP_USR','password', "oracle.jdbc.driver.OracleDriver")
        c = conn.cursor()
        procedure = 'MySchema.SP_UPDATE_JOB_STAT'
        params=['134569','COMPLETED', 'TEST','TEST']

        x=c.callproc('MySchema.SP_UPDATE_JOB_STAT', params=params)
     
        c.fetchall()
        c.close()

    except:
        instance = sys.exc_info()[1]
        print 'Exception = ' + (instance.args[0])

All I am trying to do is execute a stored proc, I can execute it from SQL Developer..
This is the error I get,
Exception = ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'SP_UPDATE_JOB_STAT'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
[SQLCode: 6550], [SQLState: 65000]




Thanks,PR