Checking a web service method

Web service methods must be checked after they are defined. This validates the syntax of the SQL statement, and all parameters.

The method checker has two options, Generate parameters and Check existing parameters.

Generate parameters

With this options, when parameters are generated, old parameters for a method are deleted and default parameters are added.

Check existing parameters

With this option, parameters are not deleted, and the method checker determines for each expression starting with a colon in the SQL statement whether there is an input parameter with the same name.

You have to specify as many input parameters as mentioned in the SQL statement, with the same name, and as many output parameters as there are output expressions.