Creating a SQL stored procedure

When you add a custom XML node to an eConnect XML document, you must supply a SQL stored procedure to process that node. The previous section added the <eConnectCustomProcedure> node to an XML document. To process XML documents that contain this node, create a stored procedure with a name that exactly matches the name of the XML node. To continue the <eConnectCustomProcedure> example, the stored procedure must be named eConnectCustomProcedure.

The custom stored procedure’s parameters must include the following: