SQL Statement Details of a Web Service Provider Method
In the SQL statement of a web service provider method, any SQL statement is allowed (SELECT, INVOKE, UPDATE, DELETE, INSERT).
For SELECT and INVOKE statements, the output parameters are generated automatically when you click the Check button, and choose for generating new parameters. These output parameters are generated from the column expressions that occur in the SELECT clause.
In the case of an INSERT, DELETE, or UPDATE statement, since these statements have no output columns, output parameters are not generated automatically.
If you want to provide the functionality of an INSERT/DELETE/UPDATE statement, and also report back to the client (send output parameter values to the caller of the web service provider), you can use the XML import method or a USoft Batch job with output parameters.
In the SQL statement of the web service method, you can then call the BatchRunner component. Use those methods that support output parameters. For more information, refer to Batch Help: The BatchRunner Component.