Oracle Stored Proc

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

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


------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Jython-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/jython-users
Loading...