Procedures are predefined programs that can be executed to query and manipulate data stored in a data source. They have scalar input and output parameters. Some of them return one or more cursors, which represent tabular output data.

TDV supports the following types of procedures.

Although different languages (TDV SQL script, Java, SQL native to data sources, XSLT, XQuery) are used to formulate procedures, they all function alike in the TDV system. You can invoke one procedure type from within another.

You can use any text editor to write a procedure, and use Studio to add it to the server. You can also use Studio’s procedure editor to create and edit any type of procedure, except Java procedures. You can add a procedure to any location except Data Services in the resource tree. For details, see Locating a Container for a TDV Resource.

For details on creating or adding procedures, see:

For a description of how to move a procedure to a Data Services container, or if you want to make a procedure available to client programs or as a Web service, you must publish that procedure. For details, see Publishing Resources.