I am trying to make a call to a procedure on a DB2 9.5 database. The response is -313 (invalid number of parameters). The required 4 input parameters and 1 output parameter are provided. The call executes successfully from the command line.
call schema1.procA ( 'string1', 'string2', 'string3', 2, ? );
Can anyone tell me what I'm doing wrong?
SQL Explorer is a JDBC database tool which can be used on any database system which provides a JDBC driver.
Calling procedures with out parameters needs a special handling which is not provided here.
Some database like MySql provide host variables which you can use to workaround this.
I don't know if db2 has such a feature.
Log in to post a comment.
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.