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
|
