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.
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.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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.