Hi !

Could anyone help me with the syntax of the stored function call
in jdbc

 CallableStatement sp;
 sp = _connection.prepareCall("{? = call addtoqueue[(?,?,?,?,?,?,?)]");
 sp.registerOutParameter(0, java.sql.Types.INTEGER);
        ...
        sp.setString( 1, "khkh" );
        ...
        sp.setString( 7, sss );
        ...

  sp.execute();
  status = sp.getInt(0);

What index will the return param have or will it be returned from the
excecut- method ??


/Micke

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html

Reply via email to