DB2 call schema.procedure

Help
Shawn
2012-06-22
2013-04-29
  • Shawn

    Shawn - 2012-06-22

    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?

     
  • Heiko Hilbert

    Heiko Hilbert - 2012-07-06

    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.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks